Reporting Group

All,

I was wondering if anyone had an easy way of getting basically export a data dumb on one machine managed with 7.5.  Security would like all information we have on one machine in our inventory.

I looked around but couldn't find an easy way of exporting all inventory data for it, if you right click export on the data you want you get a xml file thats difficult for people to read and a good bit of info is missing.

Let me know if you guys have found an easier way then screen shotting or making a manual SQL quiery as it would be much appricated!

Thanks,

Adam

Hi Adam,

You need all inventory data of only one machine put into one report? Is that it?

Actually, this would work better if Security told you what exactly they need.

Regards.

I would agree Rafael but they kind of want a "forencisics" export so they basically can say, look we have everything from all systems that manage our machines.  

Their main focus is really just all of inventory on one machine.

That can be really time consuming and difficult, to say the least. Sorry.

On Resource Manager you can find the Data Classes and Event tables where you can query the data. Actually you will only need to use the computer GUID to join the tables, most of the time.

See below:

Regards.

This may or may not work against a 7.x database, as I only have access to a 6.0 one at the moment; but if it does, then I would do the following: 

1.  Run this query: 

SELECT dc.DataTableName,dc.HistoryTableName,rus.CreatedDate,rus.ModifiedDate  
FROM DataClass dc
JOIN ResourceUpdateSummary rus ON rus.InventoryClassGuid = dc.[Guid]
WHERE rus.ResourceGuid = 'enter guid of resource here'

2.  Create SELECT * FROM <DataTableName from 1st query> WHERE _ResourceGuid = 'enter guid of resource here'

3.  Create SELECT * FROM <HistoryTableName from 1st query> WHERE _ResourceGuid = 'enter guid of resource here'

This will provide you with all inventory data for that resource. 

SK