To clarify... instead of the "CHI64" alias, it would be "ORA64"?
Mike From: [email protected] [mailto:[email protected]] On Behalf Of Marcum, John Sent: Wednesday, August 27, 2014 1:53 PM To: [email protected] Subject: [mssms] RE: A reporting question CHi64 is an alias for V_GS_Chico640. So for your new one it will be v_GS_ORACLE_640 if you only care about x64. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Wednesday, August 27, 2014 3:32 PM To: [email protected]<mailto:[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; }; ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
