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%
WHERE groupName LIKE @fbt
ORDER BY machName
SELECT ProductName, COUNT(*)
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%'