Client Management Suite

 View Only
  • 1.  workstation Usage report

    Posted Jun 02, 2010 05:14 PM
    I'm looking for a report with computer name, IP that haven’t been logged into for 30 days or even 60 days. But I'm having a hard time coming up with the correct SQL code. Can anyone help?
    Thanks
    Jen


  • 2.  RE: workstation Usage report

    Posted Jun 03, 2010 08:06 AM

    Hi skiierj,

    When you said logged, you think user logged or computer start on the network ?

    What is your version of CMS ?

    If you want help, you need to add more details !

    Best regards,


  • 3.  RE: workstation Usage report

    Posted Jun 03, 2010 11:39 AM
    Hi Charles-Henri,
    I am using CMS 6.5. I want to know which computers have not been used in 30 days.
    Does that help?

    Thanks
    Jen



  • 4.  RE: workstation Usage report

    Posted Jun 03, 2010 11:56 AM
    For CMS 6, I think, you need to add custom inventory like this thread:
    https://www-secure.symantec.com/connect/fr/downloads/script-and-ns6-custom-inventory-track-pc-startup-times
    After, you can create a report.

    Or perhaps use the report "Clients with no configuration in last N days" by default on NS6 ?


  • 5.  RE: workstation Usage report

    Posted Jun 04, 2010 02:28 PM
    I'm not getting any information. Not sure what I'm doing wrong. Why can't this just be easy?


  • 6.  RE: workstation Usage report

    Posted Jun 06, 2010 02:02 AM

    Try this (I don't have access to an NS to test, so I'm going from memory here):

    SELECT vc.Name, vc.[IP Address], ISNULL(acid.[Client Date], 'Unknown') AS [Last Active Date]
    FROM vComputer vc
    LEFT JOIN Evt_AeX_Client_Logon logon
    ON vc.Guid = logon._ResourceGuid
    AND (DATEDIFF(dd, MAX(logon.[Login Time]), GETDATE()) > 30
    OR logon.[Last Logon] IS NULL)
    LEFT JOIN Inv_AeX_AC_Identification acid
    ON vc.Guid = acid._ResourceGuid
    WHERE DATEDIFF(dd, acid.[Client Date], GETDATE()) > 30
    AND vc.IsManaged = 1
     



  • 7.  RE: workstation Usage report

    Posted Jun 07, 2010 04:06 AM

    This script create just this registry key:
    "HKLM\SOFTWARE\" & COMPANY_NAME & "\Inventory\StartupLogging\PowerOnEvent"
    

    You need to create an inventory custom for this key after.
    You can fin sample here: https://kb.altiris.com/article.asp?article=4237&p=1

    Best Regards