SCCM query to find shortcut on public desktop

[dj3094]

Hello all,

I am trying to get a report of workstations that have a shortcut on desktop. 

select SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName, SMS_G_System_SoftwareFile.FileName from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "foo.lnk" and SMS_G_System_SoftwareFile.FilePath like "C:\\Users\\Public\\Desktop\\"

 

I could not make it work as this program is installed on the machine. its just a link to web portal

[GarthMJ]

Have you enabled software inventory 

Is software inventory Inventoring .lnk files?

Is there a reason you aren't just using a configuration baseline? it is easier to do this. 

 

[keilamym]

FYI when using the LIKE command, you need to add the % variable. Here are a couple examples

SMS_G_System_SoftwareFile.FileName like "%foo.lnk"- will show all files with foo.lnk 

SMS_G_System_SoftwareFile.FileName like "%.lnk" - will show all files with .lnk 

you get the idea

 

 

 

 

[Mace]

I agree with Garth

A CI and a baseline is the simplest method to get this data.