Client Management Suite

 View Only

  • 1.  Search for some specific exe files and make report

    Posted Mar 30, 2012 03:45 AM

    Is it possible to make a sql report to show some specific exe files fore example we got a file called bioandet.exe, and then see which pc its on and which date it got installed, and maybe which version it is?



  • 2.  RE: Search for some specific exe files and make report

    Posted Mar 30, 2012 08:41 AM

    Hi pede 1788,

    Some executable info with this SQL query:

    select

    vc.Name,

    vc.[IP Address],

    ifd.Name [Executable],

    ifd.[Path]

    from

    Inv_Installed_File_Details ifd

    join vComputer vc ON ifd._ResourceGuid = vc.Guid



  • 3.  RE: Search for some specific exe files and make report

    Posted Apr 20, 2012 06:12 AM

    Is it possible to add install date?



  • 4.  RE: Search for some specific exe files and make report
    Best Answer

    Posted Apr 20, 2012 11:47 AM

    Here you go:

     

    SELECT vc.Name, vc.[IP Address], ifd.Name, ifd.Path, inst.InstallDate
    FROM Inv_Installed_File_Details ifd
    JOIN ResourceAssociation ra
       ON ra.ChildResourceGuid = ifd.FileResourceGuid
       AND ra.ResourceAssociationTypeGuid = 'EABE86D3-AAFD-487A-AF63-5C95D7511AF6'
    JOIN Inv_InstalledSoftware inst
       ON inst._SoftwareComponentGuid = ra.ParentResourceGuid
       AND inst.InstallFlag = 1
    JOIN vComputer vc
       ON ifd._ResourceGuid = vc.Guid
    WHERE LOWER(RIGHT(ifd.Name, 4)) = '.exe'

     



  • 5.  RE: Search for some specific exe files and make report

    Posted May 28, 2012 10:48 AM

    thanks, reused this right from Google. +1