Client Management Suite

 View Only

  • 1.  software last time used

    Posted Oct 11, 2014 01:14 AM

    Any of the idea to know the software when the last time used, so i can prepare the formate to remove the non required software information?



  • 2.  RE: software last time used



  • 3.  RE: software last time used
    Best Answer

    Posted Oct 11, 2014 01:20 AM

    Query

    SELECT DISTINCT adrp.DisplayName,vms.[Last Start] AS [Last Run],vc.Name, vc.[User],adrp.InstallDate,
    CASE WHEN vms.[Run Count]>= 1 THEN 'Yes' ELSE 'No' END usage FROM Vcomputer vc
    LEFT JOIN Inv_AddRemoveProgram adrp ON vc.Guid = adrp._resourceguid
    LEFT JOIN vAMMonthlySummary vms ON adrp._resourceguid = vms._resourceguid
      AND vms.[Last Start] = (SELECT max(vms.[Last Start]) FROM vAMMonthlySummary vms WHERE vms._ResourceGuid = vc.Guid)
    LEFT JOIN Inv_InstalledSoftware ins ON vms._ResourceGuid = ins._ResourceGuid
    WHERE adrp.DisplayName LIKE 'Adobe reader 8%'
    ORDER BY vc.Name


  • 4.  RE: software last time used



  • 5.  RE: software last time used

    Posted Oct 11, 2014 01:22 AM

    Installation date of software is available in query?



  • 6.  RE: software last time used

    Posted Oct 11, 2014 01:23 AM

    Yes. It will be add in my above attah query.



  • 7.  RE: software last time used

    Posted Oct 11, 2014 01:26 AM

    All SQL query available my first comment

    See this SanjayDeo7x articles

    https://www-secure.symantec.com/connect/downloads/customized-report-computer-software-installed-usage-installed-and-last-use