Correct ________________________________ From: [email protected] <[email protected]> on behalf of Garth Jones <[email protected]> Sent: Monday, September 12, 2016 12:25:14 PM To: [email protected] Subject: RE: [mssms] RE: Help with a few SQL queries
So what are the SQL view names that it created? V_GS_ TEST_Outlook and V_GS_ TEST_Outlook64? Garth Jones Chief Architect www.Enhansoft.com<http://www.enhansoft.com/> [Description: Description: cid:[email protected]]<http://www.enhansoft.com/> Enhancing Your Business [Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://www.enhansoft.com/blog>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<https://twitter.com/enhansoft>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<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:[email protected]]<http://myitforum.com/myitforumwp/community/groups/enhansoft/> Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register> From: [email protected] [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Monday, September 12, 2016 12:53 PM To: [email protected] Subject: Re: [mssms] RE: Help with a few SQL queries Yes, here is the MOF edit. pragma namespace ("\\\\.\\root\\cimv2\\SMS<file://.//root/cimv2/SMS>") #pragma deleteclass("TEST_Outlook", NOFAIL) [SMS_Report(FALSE),SMS_Group_Name("TEST_Outlook"),SMS_Class_ID("TEST_BM|TEST_Outlook|1.0"), SMS_Context_1("__ProviderArchitecture=32|uint32"), SMS_Context_2("__RequiredArchitecture=true|boolean")] Class TEST_Outlook: SMS_Class_Template { [SMS_Report(FALSE),key] string KeyName; [SMS_Report(TRUE)] String Bitness; [SMS_Report(TRUE)] String InternetMail; [SMS_Report(TRUE)] String MicrosoftExchangeServer; }; #pragma namespace ("\\\\.\\root\\cimv2\\SMS<file://.//root/cimv2/SMS>") #pragma deleteclass("TEST_Outlook_64", NOFAIL) [SMS_Report(FALSE),SMS_Group_Name("TEST_Outlook64"),SMS_Class_ID("TEST_BM|TEST_Outlook64|1.0"), SMS_Context_1("__ProviderArchitecture=64|uint32"), SMS_Context_2("__RequiredArchitecture=true|boolean")] Class TEST_Outlook_64 : SMS_Class_Template { [SMS_Report(FALSE),key] string KeyName; [SMS_Report(TRUE)] String Bitness; [SMS_Report(TRUE)] String InternetMail; [SMS_Report(TRUE)] String MicrosoftExchangeServer; }; ________________________________ From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Garth Jones <[email protected]<mailto:[email protected]>> Sent: Monday, September 12, 2016 9:19:33 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] RE: Help with a few SQL queries So did you create the MOF edit yet? Has the inventory been collected? Garth Jones Chief Architect www.Enhansoft.com<http://www.enhansoft.com/> [Description: Description: cid:[email protected]]<http://www.enhansoft.com/> Enhancing Your Business [Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://www.enhansoft.com/blog>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<https://twitter.com/enhansoft>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<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:[email protected]]<http://myitforum.com/myitforumwp/community/groups/enhansoft/> Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Sunday, September 11, 2016 10:57 PM To: [email protected]<mailto:[email protected]> Subject: Re: [mssms] RE: Help with a few SQL queries Garth, I used RegKeyToMof to inventory the key found in the following link: https://www.ronnipedersen.com/2012/11/application-requirement-for-microsoft-office-32-or-64-bit/ What I'm trying to do is inventory a list of workstations that have x86 and x64 versions of office 2013. Looking to get some help with the query. Thanks, Brian Sent from my iPhone On Sep 11, 2016, at 5:49 PM, Garth Jones <[email protected]<mailto:[email protected]>> wrote: https://www.ronnipedersen.com/2012/11/application-requirement-for-microsoft-office-32-or-64-bit/
