Client Management Suite

I need to find what inventory scans were executed on computers, and when. I'm looking for something like the table Inv_Audit_Results, but which details all inventory scans, not just the software scan.

Does anyone know if this exists, or can give a pointer to where I might start looking?

Many Thanks,
Ian./

Hello Ian,

I would suggest to check table "Inv_Inventory_Results". It contains last collection time for data gathered by Inventory agents for each computer.

Also there is report "'N' Most Recent Inventory Captures" located at Reports > Discovery and Inventory > Inventory > Cross-platform > Inventory Agent.
This reports contains list of computers where inventory was collected by Inventory Agent or Server Inventory Agent and time of inventory collection

Thanks,
Roman

Hi Roman,

That however gives no indication of when the scan started -just when the inventory was collected. So, an inventory could have been recieved at 6pm, but we have no idea when it was started, or even what type of inventory was collected.

This is important, as inventory scans can take from a few seconds to a couple of hours... And currently we seem to have have no visibility/auditing of client actions on the inventory side. As that's against the Altiris ethos, I'm thinking I just haven't found the right tables yet.. ?

Kind Regards,
Ian./

Hi Ian,

you can always check start and end time of latest Inventory scan on appropriate managed client, switching "Task Runs" option in default "Collect Full Inventory" scan policy

Here is a Query according to profiler, when you refresh this place to see all clients and their start/end time of completed inventory scan

EXECUTE tmSelectTaskInstanceData @ParentTaskInstanceGuid='225067fa-37b3-4b3a-af01-a9c37bb553d6', @TaskItemGuid=NULL, @TaskInstanceGuid=NULL, @JobNodeGuid=NULL, @InstanceStatus=NULL

@ParentTaskInstanceGuid='225067fa-37b3-4b3a-af01-a9c37bb553d6' <--- This is a GUID of "Collect Full Inventory" policy, so you can specify there another inventory scan GUID to see required information.

Thanks,

IP.

You are an absolute gem Igor. Will take a deeper look into tmSelectTaskInstanceData and see what I can extract for our reporting. Many thanks!