PENDING Query to return Computers with specifics files (With Serial Number and User Logged On)

[Polonio210]

Hello everyone,

I'm new on the community, sorry for my bad English, im still learning yet. Recently i'm working with Asset Management department in a company that have almost 3000 devices, if someone have some tips in this area i will appreciate.


I need to create a report to return all computers that have a specific file (eg. winword.exe). I already have an query, but i'm dont know to include in the following query information's about SerialNumber and the user current logged on. Someone can help me?



Select DISTINCT
SYS.Netbios_Name0 [Hostname],
SF.FileName [File Name],
SF.FileDescription [File Description],
SF.FileVersion [File Version],
SF.FileSize [File Size],
SF.FileModifiedDate [File Modified Date],
SF.FilePath [File Path]

From v_GS_SoftwareFile SF
join v_R_System_Valid SYS on SYS.ResourceID = SF.ResourceID
join v_FullCollectionMembership FCM on SYS.ResourceID = FCM.ResourceID
join v_Collection COL on FCM.CollectionID = COL.CollectionID

Where
SYS.Operating_System_Name_and0 like '%Workstation%' and -- Retirar todas as maquinas server
SF.FilePath not like '%Recycle%' and -- Retirar todos os recycles (lixeira)
SF.FileName LIKE '%winword%.exe'

 

[Polonio210]

Can someone help me? =(

 

[Prajwal Desai]

I think you can use Add or Remove programs data to find the winword installed on computers. You can use software 02D as well which is a builtin report.

 

[Polonio210]

Hello Praj,

As i said, i need to include Serial Number and the last (current) logged user in my query above.

Best Regards