Wildcards in System Management Server 1

[trickydickyuk]

I am looking for advise on using Wildcards in SMS, I want to create a query to find where all PST files are stored on User Machines, and I need to search using a wildcard sucha s a search on a normal pc where you use *.pst. Does anyone know if this is possible and if so could they send me some instructions.

Thanks a lot.

trickydickyuk.

 

[snyderj]

SMS 2 does not collect file path location so while you can report the presence of a file on a PC, you can't report the file path.

Within the SMS admin console GUI you can enter % instead of *, and/or you can select criterion properties such as subselected values, list of values, etc.

To search for *.pst in SMS you could use a query such as this:

select distinct SMS_R_System.Name, SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileSize, SMS_G_System_SoftwareFile.ModifiedDate from SMS_R_System left join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "%.pst"


What's a "normal PC"?