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”),
SMS_Class_ID (“MICROSOFT|PAGE_FILE_SETTING|1.0”) ]

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 http://msdn.microsoft.com/en-us/library/aa394245(VS.85).aspx for a description of the class.

select * from dbo.Page_File_Setting_DATA

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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