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 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)
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 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?
Share this post
Link to post
Share on other sites