Hi,

Can someone show me a way to create a custom report or help me with a SQL query which would give me a list of all assets that were assigned to a user in the last 6 months.

Input parameters: UserName

Expected output:

Asset Name, Asset Type, Serial, Price, Vendor,OrderDate

 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

I'm not sure which table you would want to pull this from, but you might be able to use the ASSET_HISTORY table. The following shows entries from the past 31 days where the user has changed on an asset:

 SELECT * FROM ORG1.ASSET_HISTORY where DESCRIPTION like 'User changed from % to %'
and TIME > DATE_SUB(NOW(), INTERVAL 31 DAY);

The main problem here is that I'm not sure if this is what you mean by an asset being assigned to a user. I believe this is more accurately showing the user that logged into a computer. I looked through this table to see if there was an explicit change recorded when the Owner assigned to the asset changed and could not find one.

Also, as far as I know, the KACE reports don't allow for input parameters, so even if you could track those changes in the Asset you would need to create a separate report for each user or modify the report every time you want to run it for a different person.

Answered 11/13/2012 by: chucksteel
Red Belt

Please log in to comment
0

Thanks Chuck.

Here is a screenshot of what I see currently when I click on Help Hub and click on a user, it opens the edit User Details area which gives me all the items the user has. If I can get a sql report which can find that for me and provide me with serial number and price along with it, that is all I'll need.  Even if it's going through 1 user at a time, that would work.

 

Answered 11/13/2012 by: nainil.ecw
Senior White Belt

Please log in to comment
0

You should be able to accomplish that using the reporting wizard. Have you tried making a report based on the asset type and including the fields you need?

Answered 11/16/2012 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity