Skip to content

Instantly share code, notes, and snippets.

@DarkAllien

DarkAllien/configuration.mof

Created January 15, 2018 07:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DarkAllien/cde72f5e501adba06a14ca8fddaf5923 to your computer and use it in GitHub Desktop.
Save DarkAllien/cde72f5e501adba06a14ca8fddaf5923 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
configuration.mof
//========================
// Added extensions start
//========================
//——————————————— // SQL 2017 Properties //———————————————
[UNION, ViewSources{"select IsReadOnly,PropertyIndex,PropertyName,PropertyNumValue,PropertyStrValue,PropertyValueType,ServiceName,SqlServiceType from sqlServiceAdvancedProperty"},ViewSpaces{"\\\\.\\root\\microsoft\\sqlserver\\computermanagement14"}, dynamic,Provider("MS_VIEW_INSTANCE_PROVIDER")]
class SQL_2017
{
[PropertySources{"IsReadOnly"} ] Boolean IsReadOnly;
[PropertySources{"PropertyIndex"},KEY ] UInt32 PropertyIndex;
[PropertySources{"PropertyName"},KEY ] String PropertyName;
[PropertySources{"PropertyNumValue"} ] UInt32 PropertyNumValue;
[PropertySources{"PropertyStrValue"} ] String PropertyStrValue;
[PropertySources{"PropertyValueType"} ] UInt32 PropertyValueType;
[PropertySources{"ServiceName"},KEY ] String ServiceName;
[PropertySources{"SqlServiceType"},KEY] UInt32 SqlServiceType;
};
//——————————————— // SQL 2016 Properties //———————————————
[UNION, ViewSources{"select IsReadOnly,PropertyIndex,PropertyName,PropertyNumValue,PropertyStrValue,PropertyValueType,ServiceName,SqlServiceType from sqlServiceAdvancedProperty"},ViewSpaces{"\\\\.\\root\\microsoft\\sqlserver\\computermanagement13"}, dynamic,Provider("MS_VIEW_INSTANCE_PROVIDER")]
class SQL_2016
{
[PropertySources{"IsReadOnly"} ] Boolean IsReadOnly;
[PropertySources{"PropertyIndex"},KEY ] UInt32 PropertyIndex;
[PropertySources{"PropertyName"},KEY ] String PropertyName;
[PropertySources{"PropertyNumValue"} ] UInt32 PropertyNumValue;
[PropertySources{"PropertyStrValue"} ] String PropertyStrValue;
[PropertySources{"PropertyValueType"} ] UInt32 PropertyValueType;
[PropertySources{"ServiceName"},KEY ] String ServiceName;
[PropertySources{"SqlServiceType"},KEY] UInt32 SqlServiceType;
};
//——————————————— // SQL 2014 Properties //———————————————
[UNION, ViewSources{"select IsReadOnly,PropertyIndex,PropertyName,PropertyNumValue,PropertyStrValue,PropertyValueType,ServiceName,SqlServiceType from sqlServiceAdvancedProperty"},ViewSpaces{"\\\\.\\root\\microsoft\\sqlserver\\computermanagement12"}, dynamic,Provider("MS_VIEW_INSTANCE_PROVIDER")]
class SQL_2014
{
[PropertySources{"IsReadOnly"} ] Boolean IsReadOnly;
[PropertySources{"PropertyIndex"},KEY ] UInt32 PropertyIndex;
[PropertySources{"PropertyName"},KEY ] String PropertyName;
[PropertySources{"PropertyNumValue"} ] UInt32 PropertyNumValue;
[PropertySources{"PropertyStrValue"} ] String PropertyStrValue;
[PropertySources{"PropertyValueType"} ] UInt32 PropertyValueType;
[PropertySources{"ServiceName"},KEY ] String ServiceName;
[PropertySources{"SqlServiceType"},KEY] UInt32 SqlServiceType;
};
//——————————————— // SQL 2012 Properties //———————————————
[UNION, ViewSources{"select IsReadOnly,PropertyIndex,PropertyName,PropertyNumValue,PropertyStrValue,PropertyValueType,ServiceName,SqlServiceType from sqlServiceAdvancedProperty"},ViewSpaces{"\\\\.\\root\\microsoft\\sqlserver\\computermanagement11"}, dynamic,Provider("MS_VIEW_INSTANCE_PROVIDER")]
class SQL_2012
{
[PropertySources{"IsReadOnly"} ] Boolean IsReadOnly;
[PropertySources{"PropertyIndex"},KEY ] UInt32 PropertyIndex;
[PropertySources{"PropertyName"},KEY ] String PropertyName;
[PropertySources{"PropertyNumValue"} ] UInt32 PropertyNumValue;
[PropertySources{"PropertyStrValue"} ] String PropertyStrValue;
[PropertySources{"PropertyValueType"} ] UInt32 PropertyValueType;
[PropertySources{"ServiceName"},KEY ] String ServiceName;
[PropertySources{"SqlServiceType"},KEY] UInt32 SqlServiceType;
};
//——————————————— // SQL 2008 Properties //———————————————
[UNION, ViewSources{"select IsReadOnly,PropertyIndex,PropertyName,PropertyNumValue,PropertyStrValue,PropertyValueType,ServiceName,SqlServiceType from sqlServiceAdvancedProperty"},ViewSpaces{"\\\\.\\root\\microsoft\\sqlserver\\computermanagement10"}, dynamic,Provider("MS_VIEW_INSTANCE_PROVIDER")]
class SQL_2008
{
[PropertySources{"IsReadOnly"} ] Boolean IsReadOnly;
[PropertySources{"PropertyIndex"},KEY ] UInt32 PropertyIndex;
[PropertySources{"PropertyName"},KEY ] String PropertyName;
[PropertySources{"PropertyNumValue"} ] UInt32 PropertyNumValue;
[PropertySources{"PropertyStrValue"} ] String PropertyStrValue;
[PropertySources{"PropertyValueType"} ] UInt32 PropertyValueType;
[PropertySources{"ServiceName"},KEY ] String ServiceName;
[PropertySources{"SqlServiceType"},KEY] UInt32 SqlServiceType;
};
//——————————————— // SQL 2000/2005 Properties //———————————————
[UNION, ViewSources{"select IsReadOnly,PropertyIndex,PropertyName,PropertyNumValue,PropertyStrValue,PropertyValueType,ServiceName,SqlServiceType from sqlServiceAdvancedProperty"},ViewSpaces{"\\\\.\\root\\microsoft\\sqlserver\\computermanagement"}, dynamic,Provider("MS_VIEW_INSTANCE_PROVIDER")]
class SQL_2000_And_2005
{
[PropertySources{"IsReadOnly"} ] Boolean IsReadOnly;
[PropertySources{"PropertyIndex"},KEY ] UInt32 PropertyIndex;
[PropertySources{"PropertyName"},KEY ] String PropertyName;
[PropertySources{"PropertyNumValue"} ] UInt32 PropertyNumValue;
[PropertySources{"PropertyStrValue"} ] String PropertyStrValue;
[PropertySources{"PropertyValueType"} ] UInt32 PropertyValueType;
[PropertySources{"ServiceName"},KEY ] String ServiceName;
[PropertySources{"SqlServiceType"},KEY] UInt32 SqlServiceType;
};
//========================
// Added extensions end
//========================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment