Client Management Suite

 View Only
  • 1.  report of software

    Posted Oct 07, 2014 03:14 AM

    report of software which was installed in the systems and has been removed from there?



  • 2.  RE: report of software
    Best Answer

    Posted Oct 07, 2014 03:29 AM

    Hi Jdsouza,

    You can create the following SQL report :

    select 
    a.DisplayName AS [Software name],
    c.Name AS [Computer Name],
    c.[IP Address]
    from Inv_AddRemoveProgram a
    join vComputer c on a._ResourceGuid = c.Guid
    where a.InstallFlag = 0 
    --AND a.DisplayName = '<<SoftName>>'

    ** The AND is commented, so if you remove the comment -- you can specify the software name

    Best regards,

     



  • 3.  RE: report of software

    Posted Oct 07, 2014 03:34 AM

    Thanks Tema.



  • 4.  RE: report of software

    Posted Oct 07, 2014 05:32 AM

    Hi Jdsouza, 

    please mark my comment as solution if it was helpful :)

    Thanks