Jump to content

User/Site Name Not Updating


Michael Sharp

Recommended Posts

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

  • 3 weeks later...
  • 3 weeks later...
Guest Ehsan

@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.

image.png

Configure the join on h_sys_accounts table as below.

image.png

In the Select Columns tab, add the columns below.

image.png

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...