Video Screencast Help

Asset User location

Created: 29 Jan 2014 | 6 comments
vikasj's picture

Hi

In Asset Management Solution 7.1 Can we get below reports

1) Before assigning any ASSET to  user how many user has use that asset previously

2) Current location of User and fixed location of user

Operating Systems:

Comments 6 CommentsJump to latest comment

SK's picture

The vAssetResource view seems to hold this information, and the following query associates the assets name with that views data:

  SELECT i.Name AS Asset,o.[User Name] AS [Owner],o.[Ownership Percentage]
  FROM vItem i  
  JOIN vAssetUserOwner o ON o._AssetGuid = i.[Guid]

The AssetAssociationChangingHistory table may also help you.

 

You can only assign one location to a user, so you could use that as their fixed location, and then use their current IP Address to work out where they currently are.  Associating subnets with locations will help here.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

vikasj's picture

Hi SK

Thats fine but I am looking for something different

Like asset moving history

E.g XYZ hostname desktop was assign to User A in Jan after that it is assign to User B after that it is assign to User C. So basically one asset is how many times it is assign to different user and there department and location all these track of asset or asset moving history report we are looking.

 

Secondaly if there are associated asset with one desktop/laptop like with desktop with associated Printer, Scanner, Headset, etc. There is no any report of Asset that associated with User in default report.

Can we created that type of report because it is high level requirement of customer end.

 

Best Regards

Vikas Jagtap

SK's picture

What data did my query return and what data does the AssetAssociationChangingHistory table hold when run against your fully populated asset database?

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

vikasj's picture

Hi SK

Query result just showing percentage of ownership.

Best Regards

Vikas Jagtap

SK's picture

What about the AssetAssociationChangingHistory table?

Can you provide the query results and that tables contents from a database that contains assets that have had multiple owners?

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

SK's picture

This may also help:-  "Saving resource data history in the CMDB" at http://www.symantec.com/docs/HOWTO62644

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.