Oops, meant for John Marcum. Anyone else, feel free to answer. :)
From: [email protected] [mailto:[email protected]] On
Behalf Of Murray, Mike
Sent: Wednesday, August 27, 2014 1:32 PM
To: [email protected]
Subject: [mssms] A reporting question
Hi John,
Quick question, In the last one you helped me with, the report SQL had the
custom registry values starting with "chi64.Chico_AssetTag0 as [Reg Asset 64]",
etc. I'm creating another report using your SQL, but it's for a different
registry value. The RegKeytoMOF text is below. I'm attaching the MOF for the
one we worked on, as well as the query you came up with. What would the Oracle
values be in the SQL? ora.ORACLE_inst_loc0 and ora.ORACLE_inst_NLS_LANG 0?
Thanks!
Mike
// RegKeyToMOF by Mark Cochrane (thanks to Skissinger, Steverac, Jonas Hettich
& Kent Agerlund)
// this section tells the inventory agent what to collect
// 8/27/2014 1:00:18 PM
#pragma namespace ("\\\\.\\root\\cimv2<file:///\\\root\cimv2>")
#pragma deleteclass("ORACLE", NOFAIL)
[DYNPROPS]
Class ORACLE
{
[key] string KeyName;
String inst_loc;
String NLS_LANG;
};
[DYNPROPS]
Instance of ORACLE
{
KeyName="RegKeyToMOF_32";
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE|inst_loc"),Dynamic,Provider("RegPropProv")]
inst_loc;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE|NLS_LANG"),Dynamic,Provider("RegPropProv")]
NLS_LANG;
};
#pragma namespace ("\\\\.\\root\\cimv2<file:///\\\root\cimv2>")
#pragma deleteclass("ORACLE_64", NOFAIL)
[DYNPROPS]
Class ORACLE_64
{
[key] string KeyName;
String inst_loc;
String NLS_LANG;
};
[DYNPROPS]
Instance of ORACLE_64
{
KeyName="RegKeyToMOF_64";
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE|inst_loc"),Dynamic,Provider("RegPropProv")]
inst_loc;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE|NLS_LANG"),Dynamic,Provider("RegPropProv")]
NLS_LANG;
};
