Active Clients Computer Summary Report

[Clint]

In ITMS 7.1, there's a "Computer Summary" report under Reports->Discovery and Inventory->Inventory->Cross-platform->Operating System.  I'd like to modify it to include only clients who've checked in with the server within the last 30 days.  For my old Altiris 6 server, I set my data purging to 30 days so reports would always have fairly current info.  Yah...I know I could do the same with 7.1 although figured maybe I should do some research on cloning/modifying the existing Computer Summary report in case someone wants historic inventory data in the future.

[Migration User]

How to get a quick count of active machines on a client facing NS?

https://www-secure.symantec.com/connect/blogs/how-get-quick-count-active-machines-client-facing-ns

[Migration User]

Hope the below thread help you https://www-secure.symantec.com/connect/forums/report-non-active-systems#comment-8814721

[SK]

Yes you can clone and then modify the reports SQL so that it includes the extra syntax.

[Gavin Sanish]

Hi Clint,

 

     You can check the following query, here you can find the list of active computers(with Agent)  and how many days it has not registered.

 

 

SELECT vc.Name, vc.Domain, vc.[OS Name], ictr.IsActive, ictr.LastRegistered, DATEDIFF(dd, ictr.LastRegistered, GETDATE()) AS Days, ihld.Manufacturer, ihld.Model, 

ihld.[Device ID] 

FROM dbo.vComputer AS vc LEFT OUTER JOIN 

dbo.vHWComputerSystem AS ihld ON vc.Guid = ihld._ResourceGuid LEFT OUTER JOIN 

dbo.Inv_Client_Task_Resources AS ictr ON vc.Guid = ictr._ResourceGuid 

WHERE (ictr.IsActive = 1) AND (DATEDIFF(dd, ictr.LastRegistered, GETDATE()) < 30)

[Clint]

I created a SQL report with this code although I didn't see any of my test VMs in them which had configuration requests within the past week.  Perhaps I'm misunderstanding what "IsActive" or "LastRegistered" implies?

[Clint]

Just curious whether you guys just left Purging Maintenance at the default 6 months in your SMC or cut it down to, say, 1 month so you wouldn't have to deal with having stale info in your database?  As an additional benefit, setting purge maintenance lower should also speed up overall data access since the server wouldn't have to comb through 6 months worth of stuff for reports/filters.

Think it's rare that someone would want historical data from Altiris...at least from my experience.  My old Altiris 6 server hardware was nothing in comparison to my SMP 7.1 server so I was somewhat forced to be more aggressive with purging maintenance.  Even though I can manage more data now, maybe it's still not worth it?

[SK]

Utilise the SQL contained within the spGetComputersToPurge stored procedure, but change the WHERE clause to use the following:

< DATEADD(DAY,-30,GETDATE())

[SK]

Historical data is determined by the companies data retention policy.  I have had one customer that required three years worth of data which had its painful momernts.

[Gavin Sanish]

Hi clint,

    Is active =1 means the agent installed machine if you changed the value to 0, you can find the unmanaged machines.

 

[Clint]

FYI: I spoke to upper management here where we have no stated desktop data retention policy so decided to spare myself some grief and set purging maintenance down to 1 month from 6.