I think that SQL view will be called v_gs_Oracle0 and v_gs_Oracle640
Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 www.Enhansoft.com<http://www.enhansoft.com/> [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0]<http://www.enhansoft.com/> Enhancing Your Business [Description: Description: Description: Description: Description: Description: Description: cid:image004.png@01CD5E19.F3C3A110]<http://be.enhansoft.com/>[Description: Description: Description: Description: Description: Description: Description: cid:image005.png@01CD5E19.F3C3A110]<https://twitter.com/enhansoft>[Description: Description: Description: Description: Description: Description: Description: cid:image006.jpg@01CD5E19.F3C3A110]<http://www.facebook.com/EnhansoftInc>[Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Enhansoft's YouTube Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: Description: Description: Description: Description: Description: cid:image007.png@01CD5E19.F3C3A110]<http://myitforum.com/myitforumwp/community/groups/enhansoft/> [cid:image007.png@01CFC2D7.D6FC9B70]<http://mms.mnscug.org/> Ask Me About Our Free SSRS Reports<http://www.enhansoft.com/pages/Free-SSRS-Reports.aspx> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Thursday, August 28, 2014 2:39 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] RegKeytoMOF question Do a select * from Oracle_640 I believe. From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Murray, Mike Sent: Thursday, August 28, 2014 12:10 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: RE: [mssms] RegKeytoMOF question OK, here’s what I have… I have no idea how I will report on this. Configuration.mof // RegKeyToMOF by Mark Cochrane (thanks to Skissinger, Steverac, Jonas Hettich & Kent Agerlund) // this section tells the inventory agent what to collect // 8/28/2014 10:08:35 AM #pragma namespace ("\\\\.\\root\\cimv2<file:///\\root\cimv2>") #pragma deleteclass("Oracle", NOFAIL) [dynamic, provider("RegProv"), ClassContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node")] Class Oracle { [key] string KeyName; }; #pragma namespace ("\\\\.\\root\\cimv2<file:///\\root\cimv2>") #pragma deleteclass("Oracle_64", NOFAIL) [dynamic, provider("RegProv"), ClassContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node")] Class Oracle_64 { [key] string KeyName; }; Import: // RegKeyToMOF by Mark Cochrane (thanks to Skissinger, Steverac, Jonas Hettich & Kent Agerlund) // this section tells the inventory agent what to report to the server // 8/28/2014 10:08:35 AM #pragma namespace ("\\\\.\\root\\cimv2\\SMS<file:///\\root\cimv2\SMS>") #pragma deleteclass("Oracle", NOFAIL) [SMS_Report(TRUE),SMS_Group_Name("Oracle"),SMS_Class_ID("Oracle"), SMS_Context_1("__ProviderArchitecture=32|uint32"), SMS_Context_2("__RequiredArchitecture=true|boolean")] Class Oracle: SMS_Class_Template { [SMS_Report(TRUE),key] string KeyName; }; #pragma namespace ("\\\\.\\root\\cimv2\\SMS<file:///\\root\cimv2\SMS>") #pragma deleteclass("Oracle_64", NOFAIL) [SMS_Report(TRUE),SMS_Group_Name("Oracle64"),SMS_Class_ID("Oracle64"), SMS_Context_1("__ProviderArchitecture=64|uint32"), SMS_Context_2("__RequiredArchitecture=true|boolean")] Class Oracle_64 : SMS_Class_Template { [SMS_Report(TRUE),key] string KeyName; }; From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger Sent: Wednesday, August 27, 2014 4:22 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: Re: [mssms] RegKeytoMOF question Ok, based on that; I think you can (mostly) use a regkeytomof edit. using regkeytomof, point at that Oracle folder (not the KEY_ ones, the Oracle one), and in regkeytomof, select the checkbox about dynamic instances. implement that; and see what you get back. If you want to post what your mof edits look like for configuration.mof and 'to be imported' .mof; feel free. You'll likely get back MORE than you actually wanted; but once you see what you get back, if you don't want some of that you can change it in the console from true to false. Sherry Kissinger On Wednesday, August 27, 2014 6:03 PM, "Murray, Mike" <mmur...@csuchico.edu<mailto:mmur...@csuchico.edu>> wrote: Attaching a couple screen shots of what data might be found under the Oracle key. Thanks, Mike From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger Sent: Wednesday, August 27, 2014 1:54 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: Re: [mssms] RegKeytoMOF question a qualified "maybe" and "it depends" when you say "everything" is it a structured "everything" ? what does a sample regkey branch look like? Sherry Kissinger On Wednesday, August 27, 2014 3:38 PM, "Murray, Mike" <mmur...@csuchico.edu<mailto:mmur...@csuchico.edu>> wrote: One of our Oracle guys wants me to inventory all computers that have some old Oracle client on them. The only way to find these is via registry values, there’s no ARP entries. He says these values will not be consistent, and there could be many. However, they would all reside under HKLM\Software\Wow6432Node\Oracle. Is it possible to dynamically collect everything under this key? Best Regards, Mike Murray Desktop Management Coordinator - IT Support Services California State University, Chico 530.898.4357 mmur...@csuchico.edu<mailto:mmur...@csuchico.edu> ________________________________ 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.
