I am attempting to write a custom SQL report and I am very close. I just can't get the last bit figured out.
Basically, the report is going to end up showing unapproved software Below is my almost working code. I am trying to put all computers and users in 1 field. I can get this working by itself, but just not sure how to group_concat it.properly.
Applications.Uninstall 'Uninstall String',
WHEN Computers.CurrentUser = '' THEN Computers.Name || ', '
ELSE Computers.Name || ' (' || Computers.CurrentUser || '), '
END AS 'Computer/Users'
FROM Computers inner join Applications on Computers.ComputerID=Applications.ComputerID
where Applications.Name LIKE '%McAfee%'
group by Applications.Name
Please sign in to leave a comment.