Query Help - Rebuild "Canned" query

[Bennie47250]

Under queries, we have a query titled "All Systems with Specified Software File Name and File Size" Since I did not know the file size, I deleted the prompt from the query. Now I want to put it back, but do not know the syntax. I’m hoping this is a canned query and someone can simply copy and paste it query here for me.

Here is the Query statement I now have

select distinct sys.Name, sys.SMSAssignedSites, sys.OperatingSystemNameandVersion, sys.ResourceDomainORWorkgroup, sys.LastLogonUserName, sys.IPAddresses, sys.IPSubnets, sys.ResourceId, sys.ResourceType from SMS_G_System_SoftwareFile as swfile inner join SMS_R_System as sys on sys.ResourceId = swfile.ResourceID where swfile.FileName like ##PRM:SMS_G_System_SoftwareFile.FileName##

Thanks
Bennie

 

[GSC]

Here you go:

select distinct sys.Name, sys.SMSAssignedSites, sys.OperatingSystemNameandVersion, sys.ResourceDomainORWorkgroup, sys.LastLogonUserName, sys.IPAddresses, sys.IPSubnets, sys.ResourceId, sys.ResourceType from SMS_G_System_SoftwareFile as swfile inner join SMS_R_System as sys on sys.ResourceId = swfile.ResourceID where swfile.FileName like ##PRM:SMS_G_System_SoftwareFile.FileName## and swfile.FileSize = ##PRM:SMS_G_System_SoftwareFile.FileSize##

I hope you find this post helpful.

Regards,
GSC