sccm sql query for find pagefile location path

There does seem to be a section in the SMS_DEF.MOF file that is designed to query the Win32_PageFileSetting class. It is disabled by default though.
[ SMS_Report (TRUE),
SMS_Group_Name (“Page File Setting”),

class Win32_PageFileSetting : SMS_Class_Template
[SMS_Report (TRUE) ]
string Caption;
[SMS_Report (TRUE) ]
string Description;
[SMS_Report (TRUE) ]
uint32 InitialSize;
[SMS_Report (TRUE) ]
uint32 MaximumSize;
[SMS_Report (TRUE), key]
string Name;
[SMS_Report (TRUE) ]
string SettingID;
Setting the entries from FALSE to TRUE might give what you are looking for. See for a description of the class.

select * from dbo.Page_File_Setting_DATA


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s