Report on Workstations without PO

Report on Workstations without PO

Hi!

SD 7.6, MS SQL

Please, how modify this reports to add users name to workstations?

select WORKSTATIONNAME from SystemInfo where WORKSTATIONID NOT IN(select distinct WORKSTATIONID from SoftwareInfo sinfo LEFT JOIN SoftwareList slist ON sinfo.SOFTWAREID=slist.SOFTWAREID where SOFTWARENAME='symantec endpoint protection client')
GROUP BY WORKSTATIONNAME

Change 'symantec endpoint protection client' to soft you needed.

                New to ADManager Plus?

                  New to ADSelfService Plus?