Michael Sharp Posted April 28, 2020 Share Posted April 28, 2020 We have found when the name of a site changes, or the name of a user changes, this is not updated in Asset Management. For example, if a user changes their name (commonly when married or divorced), their old name resides against the asset and reports. Further to this, we have adjusted the names of our sites which have not propegated e.g. renamed our Byrom Place 7th Floor site to BP7. Regards, Mike. Link to comment Share on other sites More sharing options...
James Ainsworth Posted April 28, 2020 Share Posted April 28, 2020 Hi Michael, Thanks for your post. I believe that I have been able to replicate what you are experiencing. I'll feed this back to the development team to have a look. Regards, James Link to comment Share on other sites More sharing options...
Michael Sharp Posted May 4, 2020 Author Share Posted May 4, 2020 thanks @James Ainsworth - any feedback on this as yet? Link to comment Share on other sites More sharing options...
Michael Sharp Posted May 22, 2020 Author Share Posted May 22, 2020 @James Ainsworth any feedback on this one please? Link to comment Share on other sites More sharing options...
James Ainsworth Posted May 26, 2020 Share Posted May 26, 2020 Hi Michael, I've not had any feedback as of yet. Regards, James Link to comment Share on other sites More sharing options...
Michael Sharp Posted June 15, 2020 Author Share Posted June 15, 2020 @James Ainsworth any update on this one please? Link to comment Share on other sites More sharing options...
Guest Ehsan Posted June 16, 2020 Share Posted June 16, 2020 @Michael Sharp, When viewing or utilising an Asset within the Service Manager capacity, the most up to date information about the Asset should be presented to you. We have raised a defect to update the Assets list to display the most up to date information. In relation to reports, Instead of displaying "Site" and "Owned By Name" from CMDB Assets table, you can configure your report as below. Aside from CMDB Assets table, add h_sys_accounts and h_sys_sites. Configure the join on h_sys_sites table as below. Configure the join on h_sys_accounts table as below. In the Select Columns tab, add the columns below. In my example, I gave h_sys_accounts table an alias of "user". It may be more appropriate to call it "Owned By" - You can configure this in Select Tables tab. I hope this helps. Ehsan Link to comment Share on other sites More sharing options...
Michael Sharp Posted June 17, 2020 Author Share Posted June 17, 2020 Thanks @Ehsan Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now