Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Altiris 7.1 / Report on 30 day Inactive Computers w/Primary User and Last Logged User

Created: 07 Sep 2013 • Updated: 03 Oct 2013 | 4 comments
This issue has been solved. See solution.

All,

Good Day to all,  I'm having a little trouble with a report.  I'm looking for a report which will provide me a list of computers/ 30 days of inactivity / and the user who last logged in or Primary user of the inactive computer.  I know there is a way to email the results, if this is also available it would be a massive bonus.

I've found this in the default Altiris reports but its missing the user portion to it.

Can Someone help? Thanks

DECLARE @v1_TrusteeScope nvarchar(max)
SET @v1_TrusteeScope = N'%TrusteeScope%'
 
SELECT DISTINCT    
    i.[Guid],
    i.[Name][Computer Name],
    MAX (r.[Collection Time]) [Last Collection Date] 
FROM dbo.vComputer i   
JOIN dbo.ScopeMembership sm
ON sm.[ResourceGuid] = i.Guid
AND sm.[ScopeCollectionGuid] IN (SELECT * FROM dbo.fnGetTrusteeScopeCollections (@v1_TrusteeScope)) 
JOIN dbo.Inv_Inventory_Results r     
ON r.[_ResourceGuid] = i.Guid   
                                AND r.Agent = 'Inventory Agent'
JOIN dbo.CollectionMembership cm   
ON cm.ResourceGuid = i.Guid
                JOIN dbo.vCollection it   
ON it.Guid = cm.CollectionGuid   
WHERE DATEDIFF(day,r.[Collection Time],GETDATE()) >= %Days%    
AND LOWER (i.[Name]) LIKE LOWER ('%ComputerName%')    
AND ('%Domain%' = '%' OR i.Domain = '%Domain%')
AND (('%OS Platform%' = 'Windows' AND i.[System Type] LIKE 'Win%')
OR ('%OS Platform%' = 'Unix/Linux' AND i.[System Type] LIKE 'Unix%')
OR ('%OS Platform%' = 'Macintosh' AND i.[System Type] LIKE 'Mac%')
OR ('%OS Platform%' = 'Other' AND i.[System Type] NOT LIKE 'Win%' 
AND i.[System Type] NOT LIKE 'Unix%' 
AND i.[System Type] NOT LIKE 'Mac%')
OR ('%OS Platform%' = '%'))
AND it.[Guid] =  '%Filter%'
GROUP BY i.Guid,i.Name
ORDER BY MAX (r.[Collection Time])
 
Operating Systems:

Comments 4 CommentsJump to latest comment

AJ_01's picture

I don't have sql query but below is report location for last loging

Go to the Report->All Report->Discovery and Inventory->Inventory->Cross-platform->
User ->Local User Account Information
 

Regard

AJ

SOLUTION