Kaseya Community

SQL report to show office ver by machine/machine group

  • I'm trying to get this script working, I am needing 1 particular machine group to show all machines with office * installed with versions.

    DECLARE @grp VARCHAR(50) = %fbt%

    FROM ksubscribers.dbo.vdb_Machines_List

    WHERE groupName LIKE @fbt

    ORDER BY machName

    SELECT  ProductName, COUNT(*)

     FROM [ksubscribers].[dbo].[vLicenseInfo]

     where ProductName like '%Office%'
     
      group by ProductName

     

    I am getting an error  - msg 102, level 15, state 1, line 1

    Incorrect syntax near 'fbt' -

  • you have to put '  '    around %fbt%

    it should look like so...      '%fbt%'