[mssms] SUM Data in TSQL
I have a report that shows me the count of CPU's in my SQL servers. It also should show me a count of the cores but it doesn't. The reason why is I'm counting the CPU's but each row that contains a CPU also contains I number of cores. I need to SUM the number of cores from each row and total that into the single row that is returned in my count of CPU's. How would I SUM the data from those rows? use CM_PS1 select distinct sys.name0 as 'Machine Name', hrd.SerialNumber0, COUNT (cpu.AddressWidth0) as 'Number of CPU', cpu.NumberOfCores0 'Number of Cores', --I need to add all of these together sft.SoftwareName0 as 'App Name' , sft.edition0 as 'Edition', sft.MajorVersion0 as 'Major Version', sft.MinorVersion0 as 'Minor Version', CASE WHEN hrd.IsVirtual0 IS NULL then 'No' Else hrd.IsVirtual0 End as 'Is Virtual' from v_R_System sys INNER JOIN v_GS_BDNA_BDNA_SOFTWARE_DATA_1_30 sft on sft.SMSUniqueIdentifier0 = sys.SMS_Unique_Identifier0 inner join v_GS_BDNA_BDNA_HARDWARE_DATA_1_30 hrd on hrd.SMSUniqueIdentifier0 = sys.SMS_Unique_Identifier0 INNER JOIN v_GS_Processor cpu on cpu.ResourceID = sys.ResourceID where sft.SoftwareName0 = 'SQL Server' and sft.Component0='Database Engine' group by sys.name0, hrd.SerialNumber0, cpu.NumberOfCores0, sft.SoftwareName0, sft.edition0, sft.MajorVersion0, sft.MinorVersion0, hrd.IsVirtual0 John Marcum MCITP, MCTS, MCSA Sr. Desktop Architect Bradley Arant Boult Cummings LLP [H_Logo] 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.
Re: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment
So do the install application or install packages step(s) need to actually point to the app/pkg? If so, what's the point of using the .ini file? Brian Sent from my iPhone On Jun 1, 2014, at 10:45 PM, Roland Janus roland.ja...@hispeed.ch wrote: Do you actually have “multiple install” steps in the TS? The ini will only define the variables. For installing you need steps referring to those. Have you checked the smsts.log for a reference to those variables for those install steps? -R From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Donnerstag, 29. Mai 2014 17:53 To: mssms@lists.myitforum.com; mdt...@lists.myitforum.com Subject: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment I'm using a CM12R2/MDT 2013 Integrated TS for OS deployment. Deployment to target HW seems to be working well, but one thing that isn't is installation of applications dynamically via the CS.ini file. The ZTIGather.log shows that the rules are processed, but my apps don't install. Now, if I add the steps directly to the Task Sequence using the Install Application or Install Package step, the apps install just fine. Is there something wrong with my rules file? See below. Thanks! Brian [Settings] Priority=Model, ByDesktopType, ByLaptopType Properties=MyCustomProperty [HP ProBook 6470b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6570b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6460b] Packages001=PS10002D:Install FingerPrint [ByDesktopType] Subsection=%DefaultGateway%-Desktop-%IsDesktop% [ByLaptopType] Subsection=%DefaultGateway%-Laptop-%IsLaptop% [10.20.0.1-Desktop-True] OSDComputerName=XYZDT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 [10.20.0.1-Laptop-True] OSDComputerName=YZLT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3
RE: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment
No, those steps need to use have the proper variable defined, the one you use in the ini. For the install steps (with the variable) it doesn’t matter where the definition is coming from. What do the current install steps look like? -R From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Montag, 2. Juni 2014 15:17 To: mssms@lists.myitforum.com Subject: Re: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment So do the install application or install packages step(s) need to actually point to the app/pkg? If so, what's the point of using the .ini file? Brian Sent from my iPhone On Jun 1, 2014, at 10:45 PM, Roland Janus roland.ja...@hispeed.ch mailto:roland.ja...@hispeed.ch wrote: Do you actually have “multiple install” steps in the TS? The ini will only define the variables. For installing you need steps referring to those. Have you checked the smsts.log for a reference to those variables for those install steps? -R From: listsad...@lists.myitforum.com mailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Donnerstag, 29. Mai 2014 17:53 To: mssms@lists.myitforum.com mailto:mssms@lists.myitforum.com ; mdt...@lists.myitforum.com mailto:mdt...@lists.myitforum.com Subject: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment I'm using a CM12R2/MDT 2013 Integrated TS for OS deployment. Deployment to target HW seems to be working well, but one thing that isn't is installation of applications dynamically via the CS.ini file. The ZTIGather.log shows that the rules are processed, but my apps don't install. Now, if I add the steps directly to the Task Sequence using the Install Application or Install Package step, the apps install just fine. Is there something wrong with my rules file? See below. Thanks! Brian [Settings] Priority=Model, ByDesktopType, ByLaptopType Properties=MyCustomProperty [HP ProBook 6470b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6570b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6460b] Packages001=PS10002D:Install FingerPrint [ByDesktopType] Subsection=%DefaultGateway%-Desktop-%IsDesktop% [ByLaptopType] Subsection=%DefaultGateway%-Laptop-%IsLaptop% [10.20.0.1-Desktop-True] OSDComputerName=XYZDT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 [10.20.0.1-Laptop-True] OSDComputerName=YZLT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3
RE: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment
…have you tried using the Application GUID, instead of the name? Troy L. Martin | Principal Consultant 1E | Empowering Efficient IT US Mobile: +1 (678) 898-6147 UK Phone : +44 208 326 9141 troy.mar...@1e.commailto:troy.mar...@1e.com | www.1e.comhttp://www.1e.com/ Facebookhttp://www.facebook.com/1eglobal | Twitterhttps://twitter.com/1e_global/ | YouTubehttp://www.youtube.com/1enews | Blogshttp://blogs.1e.com/ | RSShttp://blogs.1e.com/index.php/feed/ Please consider the environment before printing this e-mail From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Monday, June 2, 2014 9:17 AM To: mssms@lists.myitforum.com Subject: Re: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment So do the install application or install packages step(s) need to actually point to the app/pkg? If so, what's the point of using the .ini file? Brian Sent from my iPhone On Jun 1, 2014, at 10:45 PM, Roland Janus roland.ja...@hispeed.chmailto:roland.ja...@hispeed.ch wrote: Do you actually have “multiple install” steps in the TS? The ini will only define the variables. For installing you need steps referring to those. Have you checked the smsts.log for a reference to those variables for those install steps? -R From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Donnerstag, 29. Mai 2014 17:53 To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com; mdt...@lists.myitforum.commailto:mdt...@lists.myitforum.com Subject: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment I'm using a CM12R2/MDT 2013 Integrated TS for OS deployment. Deployment to target HW seems to be working well, but one thing that isn't is installation of applications dynamically via the CS.ini file. The ZTIGather.log shows that the rules are processed, but my apps don't install. Now, if I add the steps directly to the Task Sequence using the Install Application or Install Package step, the apps install just fine. Is there something wrong with my rules file? See below. Thanks! Brian [Settings] Priority=Model, ByDesktopType, ByLaptopType Properties=MyCustomProperty [HP ProBook 6470b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6570b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6460b] Packages001=PS10002D:Install FingerPrint [ByDesktopType] Subsection=%DefaultGateway%-Desktop-%IsDesktop% [ByLaptopType] Subsection=%DefaultGateway%-Laptop-%IsLaptop% [10.20.0.1-Desktop-True] OSDComputerName=XYZDT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 [10.20.0.1-Laptop-True] OSDComputerName=YZLT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 DISCLAIMER: This is a PRIVATE AND CONFIDENTIAL message for the ordinary user of this email address. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind 1E to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
Re: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment
I believe CM12 only needs/uses 2 num digits instead of 3. http://social.technet.microsoft.com/Forums/fr-FR/b02dcb09-0e4f-4a18-b52c-d8c7d256c626/installing-packages-durings-osd-with-mdt-2012-update-1-intergration?forum=configmanagerosd Cesar A. Meaning is NOT in words, but inside people! Dr. Myles Munroe My iPad takes half the blame for misspells. On Jun 2, 2014, at 6:46 AM, Troy Martin troy.mar...@1e.com wrote: …have you tried using the Application GUID, instead of the name? Troy L. Martin | Principal Consultant 1E | Empowering Efficient IT US Mobile: +1 (678) 898-6147 UK Phone : +44 208 326 9141 troy.mar...@1e.com | www.1e.com Facebook | Twitter | YouTube | Blogs | RSS Please consider the environment before printing this e-mail From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Monday, June 2, 2014 9:17 AM To: mssms@lists.myitforum.com Subject: Re: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment So do the install application or install packages step(s) need to actually point to the app/pkg? If so, what's the point of using the .ini file? Brian Sent from my iPhone On Jun 1, 2014, at 10:45 PM, Roland Janus roland.ja...@hispeed.ch wrote: Do you actually have “multiple install” steps in the TS? The ini will only define the variables. For installing you need steps referring to those. Have you checked the smsts.log for a reference to those variables for those install steps? -R From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Donnerstag, 29. Mai 2014 17:53 To: mssms@lists.myitforum.com; mdt...@lists.myitforum.com Subject: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment I'm using a CM12R2/MDT 2013 Integrated TS for OS deployment. Deployment to target HW seems to be working well, but one thing that isn't is installation of applications dynamically via the CS.ini file. The ZTIGather.log shows that the rules are processed, but my apps don't install. Now, if I add the steps directly to the Task Sequence using the Install Application or Install Package step, the apps install just fine. Is there something wrong with my rules file? See below. Thanks! Brian [Settings] Priority=Model, ByDesktopType, ByLaptopType Properties=MyCustomProperty [HP ProBook 6470b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6570b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6460b] Packages001=PS10002D:Install FingerPrint [ByDesktopType] Subsection=%DefaultGateway%-Desktop-%IsDesktop% [ByLaptopType] Subsection=%DefaultGateway%-Laptop-%IsLaptop% [10.20.0.1-Desktop-True] OSDComputerName=XYZDT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 [10.20.0.1-Laptop-True] OSDComputerName=YZLT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 DISCLAIMER: This is a PRIVATE AND CONFIDENTIAL message for the ordinary user of this email address. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind 1E to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
RE: [mssms] SUM Data in TSQL
Give this a try. I think you need to partition the data by computer name, and run SUM() on that. use CM_PS1 select distinct sys.name0 as 'Machine Name', hrd.SerialNumber0, COUNT (cpu.AddressWidth0) as 'Number of CPU', SUM(cpu.NumberOfCores0) OVER (PARTITION BY sys.Name0) as 'Number of Cores', sft.SoftwareName0 as 'App Name' , sft.edition0 as 'Edition', sft.MajorVersion0 as 'Major Version', sft.MinorVersion0 as 'Minor Version', CASE WHEN hrd.IsVirtual0 IS NULL then 'No' Else hrd.IsVirtual0 End as 'Is Virtual' from v_R_System sys INNER JOIN v_GS_BDNA_BDNA_SOFTWARE_DATA_1_30 sft on sft.SMSUniqueIdentifier0 = sys.SMS_Unique_Identifier0 inner join v_GS_BDNA_BDNA_HARDWARE_DATA_1_30 hrd on hrd.SMSUniqueIdentifier0 = sys.SMS_Unique_Identifier0 INNER JOIN v_GS_Processor cpu on cpu.ResourceID = sys.ResourceID where sft.SoftwareName0 = 'SQL Server' and sft.Component0='Database Engine' group by sys.name0, hrd.SerialNumber0, cpu.NumberOfCores0, sft.SoftwareName0, sft.edition0, sft.MajorVersion0, sft.MinorVersion0, hrd.IsVirtual0 Cheers, Trevor Sullivan Microsoft PowerShell MVP From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Monday, June 2, 2014 7:55 AM To: SMS List (mssms@lists.myITforum.com) Subject: [mssms] SUM Data in TSQL I have a report that shows me the count of CPU's in my SQL servers. It also should show me a count of the cores but it doesn't. The reason why is I'm counting the CPU's but each row that contains a CPU also contains I number of cores. I need to SUM the number of cores from each row and total that into the single row that is returned in my count of CPU's. How would I SUM the data from those rows? use CM_PS1 select distinct sys.name0 as 'Machine Name', hrd.SerialNumber0, COUNT (cpu.AddressWidth0) as 'Number of CPU', cpu.NumberOfCores0 'Number of Cores', --I need to add all of these together sft.SoftwareName0 as 'App Name' , sft.edition0 as 'Edition', sft.MajorVersion0 as 'Major Version', sft.MinorVersion0 as 'Minor Version', CASE WHEN hrd.IsVirtual0 IS NULL then 'No' Else hrd.IsVirtual0 End as 'Is Virtual' from v_R_System sys INNER JOIN v_GS_BDNA_BDNA_SOFTWARE_DATA_1_30 sft on sft.SMSUniqueIdentifier0 = sys.SMS_Unique_Identifier0 inner join v_GS_BDNA_BDNA_HARDWARE_DATA_1_30 hrd on hrd.SMSUniqueIdentifier0 = sys.SMS_Unique_Identifier0 INNER JOIN v_GS_Processor cpu on cpu.ResourceID = sys.ResourceID where sft.SoftwareName0 = 'SQL Server' and sft.Component0='Database Engine' group by sys.name0, hrd.SerialNumber0, cpu.NumberOfCores0, sft.SoftwareName0, sft.edition0, sft.MajorVersion0, sft.MinorVersion0, hrd.IsVirtual0 _ John Marcum MCITP, MCTS, MCSA Sr. Desktop Architect Bradley Arant Boult Cummings LLP _ _ 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.
SV: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment
Yes SCCM12 just uses 2 digits Från: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] För CESAR.ABREG0 Skickat: den 2 juni 2014 15:55 Till: mssms@lists.myitforum.com Ämne: Re: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment I believe CM12 only needs/uses 2 num digits instead of 3. http://social.technet.microsoft.com/Forums/fr-FR/b02dcb09-0e4f-4a18-b52c-d8c7d256c626/installing-packages-durings-osd-with-mdt-2012-update-1-intergration?forum=configmanagerosd Cesar A. Meaning is NOT in words, but inside people! Dr. Myles Munroe My iPad takes half the blame for misspells. On Jun 2, 2014, at 6:46 AM, Troy Martin troy.mar...@1e.commailto:troy.mar...@1e.com wrote: …have you tried using the Application GUID, instead of the name? Troy L. Martin | Principal Consultant 1E | Empowering Efficient IT US Mobile: +1 (678) 898-6147 UK Phone : +44 208 326 9141 troy.mar...@1e.commailto:troy.mar...@1e.com | www.1e.comhttp://www.1e.com/ Facebookhttp://www.facebook.com/1eglobal | Twitterhttps://twitter.com/1e_global/ | YouTubehttp://www.youtube.com/1enews | Blogshttp://blogs.1e.com/ | RSShttp://blogs.1e.com/index.php/feed/ Please consider the environment before printing this e-mail From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Monday, June 2, 2014 9:17 AM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: Re: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment So do the install application or install packages step(s) need to actually point to the app/pkg? If so, what's the point of using the .ini file? Brian Sent from my iPhone On Jun 1, 2014, at 10:45 PM, Roland Janus roland.ja...@hispeed.chmailto:roland.ja...@hispeed.ch wrote: Do you actually have “multiple install” steps in the TS? The ini will only define the variables. For installing you need steps referring to those. Have you checked the smsts.log for a reference to those variables for those install steps? -R From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Donnerstag, 29. Mai 2014 17:53 To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com; mdt...@lists.myitforum.commailto:mdt...@lists.myitforum.com Subject: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment I'm using a CM12R2/MDT 2013 Integrated TS for OS deployment. Deployment to target HW seems to be working well, but one thing that isn't is installation of applications dynamically via the CS.ini file. The ZTIGather.log shows that the rules are processed, but my apps don't install. Now, if I add the steps directly to the Task Sequence using the Install Application or Install Package step, the apps install just fine. Is there something wrong with my rules file? See below. Thanks! Brian [Settings] Priority=Model, ByDesktopType, ByLaptopType Properties=MyCustomProperty [HP ProBook 6470b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6570b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6460b] Packages001=PS10002D:Install FingerPrint [ByDesktopType] Subsection=%DefaultGateway%-Desktop-%IsDesktop% [ByLaptopType] Subsection=%DefaultGateway%-Laptop-%IsLaptop% [10.20.0.1-Desktop-True] OSDComputerName=XYZDT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 [10.20.0.1-Laptop-True] OSDComputerName=YZLT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 DISCLAIMER: This is a PRIVATE AND CONFIDENTIAL message for the ordinary user of this email address. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind 1E to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
[mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database?
Hi all, I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I'm not overly sure what permissions are required on the SQL side to get this to work. Ideally I'd like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that's it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards, Cliff
RE: [mssms] SUM Data in TSQL
Use the case statement with sum to add all the cores. Ex:sum(case when cpu.numberofcores not like '' then 1 else null end) Something like this.. Not infornt of sql to get right syntax. Regards, Eswar Koneti www.eskonr.com --- Original Message --- From: Marcum, John jmar...@babc.com Sent: June 2, 2014 8:57 PM To: SMS List (mssms@lists.myITforum.com) mssms@lists.myITforum.com Subject: [mssms] SUM Data in TSQL I have a report that shows me the count of CPU's in my SQL servers. It also should show me a count of the cores but it doesn't. The reason why is I'm counting the CPU's but each row that contains a CPU also contains I number of cores. I need to SUM the number of cores from each row and total that into the single row that is returned in my count of CPU's. How would I SUM the data from those rows? use CM_PS1 select distinct sys.name0 as 'Machine Name', hrd.SerialNumber0, COUNT (cpu.AddressWidth0) as 'Number of CPU', cpu.NumberOfCores0 'Number of Cores', --I need to add all of these together sft.SoftwareName0 as 'App Name' , sft.edition0 as 'Edition', sft.MajorVersion0 as 'Major Version', sft.MinorVersion0 as 'Minor Version', CASE WHEN hrd.IsVirtual0 IS NULL then 'No' Else hrd.IsVirtual0 End as 'Is Virtual' from v_R_System sys INNER JOIN v_GS_BDNA_BDNA_SOFTWARE_DATA_1_30 sft on sft.SMSUniqueIdentifier0 = sys.SMS_Unique_Identifier0 inner join v_GS_BDNA_BDNA_HARDWARE_DATA_1_30 hrd on hrd.SMSUniqueIdentifier0 = sys.SMS_Unique_Identifier0 INNER JOIN v_GS_Processor cpu on cpu.ResourceID = sys.ResourceID where sft.SoftwareName0 = 'SQL Server' and sft.Component0='Database Engine' group by sys.name0, hrd.SerialNumber0, cpu.NumberOfCores0, sft.SoftwareName0, sft.edition0, sft.MajorVersion0, sft.MinorVersion0, hrd.IsVirtual0 John Marcum MCITP, MCTS, MCSA Sr. Desktop Architect Bradley Arant Boult Cummings LLP [H_Logo] 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.
[mssms] IBCM not working after CM12 R2 upgrade
Hello, I'm fairly new to SCCM. Currently running CM12 R2, one primary and one internet facing MP, DP, SUP (both on Server 2008 R2). Before upgrading to R2 from SP1, IBCM was functioning using PKI. After upgrade, internet clients are not communicating. On the clients, CcmMessaging.log states Post to https://ibcmsiteserver.domain.com/ccm_system/request failed with 0x87d00231 LocationServices.log shows LSUpdateInternetManagementPoints: Failed to retrieve internet MPs from MP ibcmsiteserver.domain.com with error 0x87d00231, retaining previous list Anyone run into this after the R2 upgrade? And how did you resolve it? Thanks, Jeff
Re: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database?
This may be devil's advocate... but is this CM? and that database is the CM database? If so, what's the blocker to use SRS, creating a report with whatever it is you need to dump, and in SRS scheduling that to run and export the results in CSV to a share somewhere? (or email it to some poor admin) Sherry Kissinger On Monday, June 2, 2014 9:58 AM, Cliff Hobbs cl...@faqshop.com wrote: Hi all, I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I’m not overly sure what permissions are required on the SQL side to get this to work. Ideally I’d like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that’s it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards, Cliff
RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database?
Yes, I also responded in kind elsewhere. Also (for info) pointed to using Excel directly on the database http://blogs.technet.com/b/manageabilityguys/archive/2013/04/11/mms-2013-udb-338-additional-content.aspx was an excellent MMS session on this Date: Mon, 2 Jun 2014 08:40:01 -0700 From: slkissin...@sbcglobal.net Subject: Re: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? To: mssms@lists.myitforum.com This may be devil's advocate... but is this CM? and that database is the CM database? If so, what's the blocker to use SRS, creating a report with whatever it is you need to dump, and in SRS scheduling that to run and export the results in CSV to a share somewhere? (or email it to some poor admin) Sherry Kissinger On Monday, June 2, 2014 9:58 AM, Cliff Hobbs cl...@faqshop.com wrote: Hi all, I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I’m not overly sure what permissions are required on the SQL side to get this to work. Ideally I’d like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that’s it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards,Cliff
RE: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment
Right, forgot that. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Olsson Mats Sent: Montag, 2. Juni 2014 16:26 To: mssms@lists.myitforum.com Subject: SV: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment Yes SCCM12 just uses 2 digits Från: listsad...@lists.myitforum.com mailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] För CESAR.ABREG0 Skickat: den 2 juni 2014 15:55 Till: mssms@lists.myitforum.com mailto:mssms@lists.myitforum.com Ämne: Re: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment I believe CM12 only needs/uses 2 num digits instead of 3. http://social.technet.microsoft.com/Forums/fr-FR/b02dcb09-0e4f-4a18-b52c-d8c7d256c626/installing-packages-durings-osd-with-mdt-2012-update-1-intergration?forum=configmanagerosd Cesar A. Meaning is NOT in words, but inside people! Dr. Myles Munroe My iPad takes half the blame for misspells. On Jun 2, 2014, at 6:46 AM, Troy Martin troy.mar...@1e.com mailto:troy.mar...@1e.com wrote: …have you tried using the Application GUID, instead of the name? Troy L. Martin | Principal Consultant 1E | Empowering Efficient IT US Mobile: +1 (678) 898-6147 UK Phone : +44 208 326 9141 mailto:troy.mar...@1e.com troy.mar...@1e.com | http://www.1e.com/ www.1e.com http://www.facebook.com/1eglobal Facebook | https://twitter.com/1e_global/ Twitter | http://www.youtube.com/1enews YouTube | http://blogs.1e.com/ Blogs | http://blogs.1e.com/index.php/feed/ RSS Please consider the environment before printing this e-mail From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Monday, June 2, 2014 9:17 AM To: mssms@lists.myitforum.com mailto:mssms@lists.myitforum.com Subject: Re: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment So do the install application or install packages step(s) need to actually point to the app/pkg? If so, what's the point of using the .ini file? Brian Sent from my iPhone On Jun 1, 2014, at 10:45 PM, Roland Janus roland.ja...@hispeed.ch mailto:roland.ja...@hispeed.ch wrote: Do you actually have “multiple install” steps in the TS? The ini will only define the variables. For installing you need steps referring to those. Have you checked the smsts.log for a reference to those variables for those install steps? -R From: listsad...@lists.myitforum.com mailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Donnerstag, 29. Mai 2014 17:53 To: mssms@lists.myitforum.com mailto:mssms@lists.myitforum.com ; mdt...@lists.myitforum.com mailto:mdt...@lists.myitforum.com Subject: [mssms] CS.ini processes rules but doesn't install apps in ZTI deployment I'm using a CM12R2/MDT 2013 Integrated TS for OS deployment. Deployment to target HW seems to be working well, but one thing that isn't is installation of applications dynamically via the CS.ini file. The ZTIGather.log shows that the rules are processed, but my apps don't install. Now, if I add the steps directly to the Task Sequence using the Install Application or Install Package step, the apps install just fine. Is there something wrong with my rules file? See below. Thanks! Brian [Settings] Priority=Model, ByDesktopType, ByLaptopType Properties=MyCustomProperty [HP ProBook 6470b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6570b] Packages001=PS10002D:Install FingerPrint [HP ProBook 6460b] Packages001=PS10002D:Install FingerPrint [ByDesktopType] Subsection=%DefaultGateway%-Desktop-%IsDesktop% [ByLaptopType] Subsection=%DefaultGateway%-Laptop-%IsLaptop% [10.20.0.1-Desktop-True] OSDComputerName=XYZDT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 [10.20.0.1-Laptop-True] OSDComputerName=YZLT-#Left(%SerialNumber%,8)# MachineObjectOU= Packages001=PS100016:Install FireFox Packages002=PS100038:Install Java x64 Applications001=Google Chrome 65.223.114 Applications002=Adobe Flash Player 12.0.0.43 Applications003=Adobe Reader 11.0.0.3 _ DISCLAIMER: This is a PRIVATE AND CONFIDENTIAL message for the ordinary user of this email address. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind 1E to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database?
Why not create the stored procedures in a separate database, so as to ensure portability, and avoid changes to the ConfigMgr database? Then, simply grant the service account the following permissions: 1. db_datareader role (on the ConfigMgr database) 2. Execute (on stored procedures in the external database) Cheers, Trevor Sullivan Microsoft PowerShell MVP From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Wallace Sent: Monday, June 2, 2014 10:48 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Yes, I also responded in kind elsewhere. Also (for info) pointed to using Excel directly on the database http://blogs.technet.com/b/manageabilityguys/archive/2013/04/11/mms-2013-ud b-338-additional-content.aspx http://blogs.technet.com/b/manageabilityguys/archive/2013/04/11/mms-2013-udb -338-additional-content.aspx was an excellent MMS session on this _ Date: Mon, 2 Jun 2014 08:40:01 -0700 From: slkissin...@sbcglobal.net mailto:slkissin...@sbcglobal.net Subject: Re: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? To: mssms@lists.myitforum.com mailto:mssms@lists.myitforum.com This may be devil's advocate... but is this CM? and that database is the CM database? If so, what's the blocker to use SRS, creating a report with whatever it is you need to dump, and in SRS scheduling that to run and export the results in CSV to a share somewhere? (or email it to some poor admin) Sherry Kissinger On Monday, June 2, 2014 9:58 AM, Cliff Hobbs cl...@faqshop.com mailto:cl...@faqshop.com wrote: Hi all, I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I'm not overly sure what permissions are required on the SQL side to get this to work. Ideally I'd like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that's it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards, Cliff
[mssms] Re: IBCM not working after CM12 R2 upgrade
Please disregard. Problem has been resolved. Thanks, On Mon, Jun 2, 2014 at 11:08 AM, Jeff Burke jeffburk...@gmail.com wrote: Hello, I'm fairly new to SCCM. Currently running CM12 R2, one primary and one internet facing MP, DP, SUP (both on Server 2008 R2). Before upgrading to R2 from SP1, IBCM was functioning using PKI. After upgrade, internet clients are not communicating. On the clients, CcmMessaging.log states Post to https://ibcmsiteserver.domain.com/ccm_system/request failed with 0x87d00231 LocationServices.log shows LSUpdateInternetManagementPoints: Failed to retrieve internet MPs from MP ibcmsiteserver.domain.com with error 0x87d00231, retaining previous list Anyone run into this after the R2 upgrade? And how did you resolve it? Thanks, Jeff
[mssms] Re: IBCM not working after CM12 R2 upgrade
Forgot to post the resolution - CRL checking was enabled for PKI after upgrade. Once disabled, internet clients were able to communicate with the internet facing MP. On Mon, Jun 2, 2014 at 2:17 PM, Jeff Burke jeffburk...@gmail.com wrote: Please disregard. Problem has been resolved. Thanks, On Mon, Jun 2, 2014 at 11:08 AM, Jeff Burke jeffburk...@gmail.com wrote: Hello, I'm fairly new to SCCM. Currently running CM12 R2, one primary and one internet facing MP, DP, SUP (both on Server 2008 R2). Before upgrading to R2 from SP1, IBCM was functioning using PKI. After upgrade, internet clients are not communicating. On the clients, CcmMessaging.log states Post to https://ibcmsiteserver.domain.com/ccm_system/request failed with 0x87d00231 LocationServices.log shows LSUpdateInternetManagementPoints: Failed to retrieve internet MPs from MP ibcmsiteserver.domain.com with error 0x87d00231, retaining previous list Anyone run into this after the R2 upgrade? And how did you resolve it? Thanks, Jeff
RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database?
That'd be the only way to do it (and of course only reading the views) It seems, however to be reengineering what the SCCM product already offers - SSRS is expressly designed to access the views and deliver that content in the required format and also with the scheduling requested. From: tsul...@gmail.com To: mssms@lists.myitforum.com Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Date: Mon, 2 Jun 2014 11:47:26 -0500 Why not create the stored procedures in a separate database, so as to ensure portability, and avoid changes to the ConfigMgr database? Then, simply grant the service account the following permissions: 1. db_datareader role (on the ConfigMgr database)2. Execute (on stored procedures in the external database) Cheers,Trevor SullivanMicrosoft PowerShell MVP From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Wallace Sent: Monday, June 2, 2014 10:48 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Yes, I also responded in kind elsewhere. Also (for info) pointed to using Excel directly on the database http://blogs.technet.com/b/manageabilityguys/archive/2013/04/11/mms-2013-udb-338-additional-content.aspx was an excellent MMS session on this Date: Mon, 2 Jun 2014 08:40:01 -0700 From: slkissin...@sbcglobal.net Subject: Re: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? To: mssms@lists.myitforum.comThis may be devil's advocate... but is this CM? and that database is the CM database? If so, what's the blocker to use SRS, creating a report with whatever it is you need to dump, and in SRS scheduling that to run and export the results in CSV to a share somewhere? (or email it to some poor admin) Sherry KissingerOn Monday, June 2, 2014 9:58 AM, Cliff Hobbs cl...@faqshop.com wrote: Hi all, I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I’m not overly sure what permissions are required on the SQL side to get this to work. Ideally I’d like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that’s it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards,Cliff
RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database?
Thanks for all the replies (x2 Jason ;-) Yes this is CM12 SP1 and the reason for doing this (sorry should have said), is to have the Scheduled Tasks run to dump the data into the CSVs from where they can be imported to Remedy. I'm inheriting this solution - agree it's not the most elegant but my brief is purely to get it working which it isn't at the moment as seems to be permission-related (if I run the Scheduled Task as my Admin account works fine, but not when they use the Service Account they've created). Sure I could clone my admin account but that would give the Service Account too many permissions and access to things it shouldn't have. Many thanks and kind regards, Cliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Wallace Sent: 02 Jun 2014 16:48 To: mssms@lists.myitforum.com Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Yes, I also responded in kind elsewhere. Also (for info) pointed to using Excel directly on the database http://blogs.technet.com/b/manageabilityguys/archive/2013/04/11/mms-2013-ud b-338-additional-content.aspx http://blogs.technet.com/b/manageabilityguys/archive/2013/04/11/mms-2013-udb -338-additional-content.aspx was an excellent MMS session on this _ Date: Mon, 2 Jun 2014 08:40:01 -0700 From: slkissin...@sbcglobal.net mailto:slkissin...@sbcglobal.net Subject: Re: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? To: mssms@lists.myitforum.com mailto:mssms@lists.myitforum.com This may be devil's advocate... but is this CM? and that database is the CM database? If so, what's the blocker to use SRS, creating a report with whatever it is you need to dump, and in SRS scheduling that to run and export the results in CSV to a share somewhere? (or email it to some poor admin) Sherry Kissinger On Monday, June 2, 2014 9:58 AM, Cliff Hobbs cl...@faqshop.com mailto:cl...@faqshop.com wrote: Hi all, I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I'm not overly sure what permissions are required on the SQL side to get this to work. Ideally I'd like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that's it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards, Cliff
RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database?
So these are pre-exisiting stored procedures created where - in the SCCM database? They were created by Remedy themselves? Any word in their documentation on this? From: lists...@faqshop.com To: mssms@lists.myitforum.com Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Date: Mon, 2 Jun 2014 20:30:12 +0100 Thanks for all the replies (x2 Jason ;-) Yes this is CM12 SP1 and the reason for doing this (sorry should have said), is to have the Scheduled Tasks run to dump the data into the CSVs from where they can be imported to Remedy. I’m inheriting this solution – agree it’s not the most elegant but my brief is purely to get it working which it isn’t at the moment as seems to be permission-related (if I run the Scheduled Task as my Admin account works fine, but not when they use the Service Account they’ve created). Sure I could clone my admin account but that would give the Service Account too many permissions and access to things it shouldn’t have. Many thanks and kind regards,Cliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Wallace Sent: 02 Jun 2014 16:48 To: mssms@lists.myitforum.com Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Yes, I also responded in kind elsewhere. Also (for info) pointed to using Excel directly on the database http://blogs.technet.com/b/manageabilityguys/archive/2013/04/11/mms-2013-udb-338-additional-content.aspx was an excellent MMS session on this Date: Mon, 2 Jun 2014 08:40:01 -0700 From: slkissin...@sbcglobal.net Subject: Re: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? To: mssms@lists.myitforum.comThis may be devil's advocate... but is this CM? and that database is the CM database? If so, what's the blocker to use SRS, creating a report with whatever it is you need to dump, and in SRS scheduling that to run and export the results in CSV to a share somewhere? (or email it to some poor admin) Sherry KissingerOn Monday, June 2, 2014 9:58 AM, Cliff Hobbs cl...@faqshop.com wrote: Hi all, I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I’m not overly sure what permissions are required on the SQL side to get this to work. Ideally I’d like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that’s it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards,Cliff
RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database?
Oh, and what is the message that SQL is giving out? Msg 229 - error on select . . . .? Have you checked the ownership chains on the stored procedure and the views that it is accessing? Oh, and if these are someone else's stored procedure have you any clue as to whether they are accessing the views - I bet they aren't From: lists...@faqshop.com To: mssms@lists.myitforum.com Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Date: Mon, 2 Jun 2014 20:30:12 +0100 Thanks for all the replies (x2 Jason ;-) Yes this is CM12 SP1 and the reason for doing this (sorry should have said), is to have the Scheduled Tasks run to dump the data into the CSVs from where they can be imported to Remedy. I’m inheriting this solution – agree it’s not the most elegant but my brief is purely to get it working which it isn’t at the moment as seems to be permission-related (if I run the Scheduled Task as my Admin account works fine, but not when they use the Service Account they’ve created). Sure I could clone my admin account but that would give the Service Account too many permissions and access to things it shouldn’t have. Many thanks and kind regards,Cliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Wallace Sent: 02 Jun 2014 16:48 To: mssms@lists.myitforum.com Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Yes, I also responded in kind elsewhere. Also (for info) pointed to using Excel directly on the database http://blogs.technet.com/b/manageabilityguys/archive/2013/04/11/mms-2013-udb-338-additional-content.aspx was an excellent MMS session on this Date: Mon, 2 Jun 2014 08:40:01 -0700 From: slkissin...@sbcglobal.net Subject: Re: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? To: mssms@lists.myitforum.comThis may be devil's advocate... but is this CM? and that database is the CM database? If so, what's the blocker to use SRS, creating a report with whatever it is you need to dump, and in SRS scheduling that to run and export the results in CSV to a share somewhere? (or email it to some poor admin) Sherry KissingerOn Monday, June 2, 2014 9:58 AM, Cliff Hobbs cl...@faqshop.com wrote: Hi all, I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I’m not overly sure what permissions are required on the SQL side to get this to work. Ideally I’d like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that’s it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards,Cliff
RE: [mssms] Re: IBCM not working after CM12 R2 upgrade
Disabling CRL checking is not a best practice and would be a bad thing to do. I would give that a second thought, and research what it would take to so that CRL checking can be enabled. Essentially, clients need to be able to access the CRL Distribution Points whether they’re on the intranet and/or Internet. Troy L. Martin | Principal Consultant 1E | Empowering Efficient IT US Mobile: +1 (678) 898-6147 UK Phone : +44 208 326 9141 troy.mar...@1e.commailto:troy.mar...@1e.com | www.1e.comhttp://www.1e.com/ Facebookhttp://www.facebook.com/1eglobal | Twitterhttps://twitter.com/1e_global/ | YouTubehttp://www.youtube.com/1enews | Blogshttp://blogs.1e.com/ | RSShttp://blogs.1e.com/index.php/feed/ Please consider the environment before printing this e-mail From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jeff Burke Sent: Monday, June 2, 2014 2:24 PM To: mssms@lists.myitforum.com Subject: [mssms] Re: IBCM not working after CM12 R2 upgrade Forgot to post the resolution - CRL checking was enabled for PKI after upgrade. Once disabled, internet clients were able to communicate with the internet facing MP. On Mon, Jun 2, 2014 at 2:17 PM, Jeff Burke jeffburk...@gmail.commailto:jeffburk...@gmail.com wrote: Please disregard. Problem has been resolved. Thanks, On Mon, Jun 2, 2014 at 11:08 AM, Jeff Burke jeffburk...@gmail.commailto:jeffburk...@gmail.com wrote: Hello, I'm fairly new to SCCM. Currently running CM12 R2, one primary and one internet facing MP, DP, SUP (both on Server 2008 R2). Before upgrading to R2 from SP1, IBCM was functioning using PKI. After upgrade, internet clients are not communicating. On the clients, CcmMessaging.log states Post to https://ibcmsiteserver.domain.com/ccm_system/request failed with 0x87d00231 LocationServices.log shows LSUpdateInternetManagementPoints: Failed to retrieve internet MPs from MP ibcmsiteserver.domain.comhttp://ibcmsiteserver.domain.com with error 0x87d00231, retaining previous list Anyone run into this after the R2 upgrade? And how did you resolve it? Thanks, Jeff DISCLAIMER: This is a PRIVATE AND CONFIDENTIAL message for the ordinary user of this email address. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind 1E to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
[mssms] Mighty MOFin' power rangers
I have a problem/question with a MOF edit. I am moving some MOF edits I made from 2007 to 2012 and am running into a little trouble with the ones that have conditional 32/64 components to them. Let's take Winlogon for example. I collect data from the Winlogon reg key to catch autologon machines. I have the configuration.mof edited and working... but I am running into trouble importing the sms_def.mof when there is conditional statements in the reporting class. When I try to import this into SCCM 2012, it complains that there are duplicates. The importer is not smart enough to know that only one or the other reporting classes can be run. Works fine in SCCM 2007. Anything I can do about it?Can I edit the sms_def.mof manually or make SCCM override this error checking? Does SCCM 2012 remove the ability to merge/union 32 and 64bit registry reads into a single reporting class (that's been available since SMS 2003?) [cid:image001.png@01CF7E7A.0C169470] // :[-Start-AutoLogon Reporting Class-Start-]: #pragma namespace (.\\root\\cimv2\\SMS) #pragma deleteclass(WinLogon, NOFAIL) [SMS_Report(TRUE),SMS_Group_Name(WinLogon),SMS_Class_ID(MICROSOFT|WinLogon|1.0), SMS_Context_1(__ProviderArchitecture=32|uint32), SMS_Context_2(__RequiredArchitecture=true|boolean)] Class WinLogon: SMS_Class_Template { [SMS_Report(TRUE),key] string KeyName; [SMS_Report(FALSE)] String ReportBootOk; [SMS_Report(FALSE)] String Shell; [SMS_Report(FALSE)] String PreCreateKnownFolders; [SMS_Report(FALSE)] String Userinit; [SMS_Report(FALSE)] String VMApplet; [SMS_Report(FALSE)] Uint32 AutoRestartShell; [SMS_Report(FALSE)] String Background; [SMS_Report(FALSE)] String CachedLogonsCount; [SMS_Report(FALSE)] String DebugServerCommand; [SMS_Report(FALSE)] Uint32 ForceUnlockLogon; [SMS_Report(FALSE)] String LegalNoticeCaption; [SMS_Report(FALSE)] String LegalNoticeText; [SMS_Report(FALSE)] Uint32 PasswordExpiryWarning; [SMS_Report(FALSE)] String PowerdownAfterShutdown; [SMS_Report(FALSE)] String ShutdownWithoutLogon; [SMS_Report(FALSE)] String WinStationsDisabled; [SMS_Report(FALSE)] Uint32 DisableCAD; [SMS_Report(FALSE)] String scremoveoption; [SMS_Report(FALSE)] Uint32 ShutdownFlags; [SMS_Report(TRUE)] String AutoAdminLogon; [SMS_Report(TRUE)] String DefaultUserName; [SMS_Report(FALSE)] String DefaultDomainName; [SMS_Report(FALSE)] String DefaultPassword; [SMS_Report(FALSE)] Uint32 AutoLogonCount; [SMS_Report(FALSE)] Uint32 GpNetworkStartTimeoutPolicyValue; }; #pragma namespace (.\\root\\cimv2\\SMS) #pragma deleteclass(WinLogon_64, NOFAIL) [SMS_Report(TRUE),SMS_Group_Name(WinLogon),SMS_Class_ID(MICROSOFT|WinLogon|1.0), SMS_Context_1(__ProviderArchitecture=64|uint32), SMS_Context_2(__RequiredArchitecture=true|boolean)] Class WinLogon_64 : SMS_Class_Template { [SMS_Report(TRUE),key] string KeyName; [SMS_Report(FALSE)] String ReportBootOk; [SMS_Report(FALSE)] String Shell; [SMS_Report(FALSE)] String PreCreateKnownFolders; [SMS_Report(FALSE)] String Userinit; [SMS_Report(FALSE)] String VMApplet; [SMS_Report(FALSE)] Uint32 AutoRestartShell; [SMS_Report(FALSE)] String Background; [SMS_Report(FALSE)] String CachedLogonsCount; [SMS_Report(FALSE)] String DebugServerCommand; [SMS_Report(FALSE)] Uint32 ForceUnlockLogon; [SMS_Report(FALSE)] String LegalNoticeCaption; [SMS_Report(FALSE)] String LegalNoticeText; [SMS_Report(FALSE)] Uint32 PasswordExpiryWarning; [SMS_Report(FALSE)] String PowerdownAfterShutdown; [SMS_Report(FALSE)] String ShutdownWithoutLogon; [SMS_Report(FALSE)] String WinStationsDisabled; [SMS_Report(FALSE)] Uint32 DisableCAD; [SMS_Report(FALSE)] String scremoveoption; [SMS_Report(FALSE)] Uint32 ShutdownFlags; [SMS_Report(TRUE)] String AutoAdminLogon; [SMS_Report(TRUE)] String DefaultUserName; [SMS_Report(FALSE)] String DefaultDomainName; [SMS_Report(FALSE)] String DefaultPassword; [SMS_Report(FALSE)] Uint32 AutoLogonCount; [SMS_Report(FALSE)] Uint32 GpNetworkStartTimeoutPolicyValue; }; // :[-End-AutoLogon Reporting Class-End-]: Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.
Re: [mssms] Mighty MOFin' power rangers
Yeah, it gets complicated/counter-intuitive. Try this and ONLY this as a toBeImport.Mof: #pragma namespace (.\\root\\cimv2\\SMS) #pragma deleteclass(WinLogon, NOFAIL) [SMS_Report(TRUE),SMS_Group_Name(WinLogon),SMS_Class_ID(WinLogon)] Class WinLogon: SMS_Class_Template { [SMS_Report(TRUE),key] string KeyName; [SMS_Report(FALSE)] String ReportBootOk; [SMS_Report(FALSE)] String Shell; [SMS_Report(FALSE)] String PreCreateKnownFolders; [SMS_Report(FALSE)] String Userinit; [SMS_Report(FALSE)] String VMApplet; [SMS_Report(FALSE)] Uint32 AutoRestartShell; [SMS_Report(FALSE)] String Background; [SMS_Report(FALSE)] String CachedLogonsCount; [SMS_Report(FALSE)] String DebugServerCommand; [SMS_Report(FALSE)] Uint32 ForceUnlockLogon; [SMS_Report(FALSE)] String LegalNoticeCaption; [SMS_Report(FALSE)] String LegalNoticeText; [SMS_Report(FALSE)] Uint32 PasswordExpiryWarning; [SMS_Report(FALSE)] String PowerdownAfterShutdown; [SMS_Report(FALSE)] String ShutdownWithoutLogon; [SMS_Report(FALSE)] String WinStationsDisabled; [SMS_Report(FALSE)] Uint32 DisableCAD; [SMS_Report(FALSE)] String scremoveoption; [SMS_Report(FALSE)] Uint32 ShutdownFlags; [SMS_Report(TRUE)] String AutoAdminLogon; [SMS_Report(TRUE)] String DefaultUserName; [SMS_Report(FALSE)] String DefaultDomainName; [SMS_Report(FALSE)] String DefaultPassword; [SMS_Report(FALSE)] Uint32 AutoLogonCount; [SMS_Report(FALSE)] Uint32 GpNetworkStartTimeoutPolicyValue; }; From both a 32-bit and a 64-bit OS, confirm that box types report what you think you want that to report. Here's the short answer of why it works: CM12 now is both a 64bit client and a 32bit client. So for this SPECIFIC example, the winlogin regkeys you are looking for aren't in the look elsewhere for 32-bit app information. On both 32 and 64 bit OS... it's in hklm\software\normal... NotTheWin6432node Redirected location if the OS happens to be 64. The answer changes if you ARE looking for 32-bit app information on a 64-bit system. So don't just take the next mof edit and do the exact same thing. That might be the wrong answer for the next custom edit. Oh, and I skipped about 3 steps in my explanation. the real problem is that you are trying to import a cm07 sms_def.mof edit. and cm12 just doesn't get it. It needs to be cm12 to be imported from regkeytomof. You can't just copy/paste from your cm07 mof files straight into cm12... there are subtle changes to any custom mof edits that just don't work in cm12 (as you've seen, the unique class id message) On Monday, June 2, 2014 4:05 PM, Miller, Todd todd-mil...@uiowa.edu wrote: I have a problem/question with a MOF edit. I am moving some MOF edits I made from 2007 to 2012 and am running into a little trouble with the ones that have conditional 32/64 components to them. Let’s take Winlogon for example. I collect data from the Winlogon reg key to catch autologon machines. I have the configuration.mof edited and working… but I am running into trouble importing the sms_def.mof when there is conditional statements in the reporting class. When I try to import this into SCCM 2012, it complains that there are duplicates. The importer is not smart enough to know that only one or the other reporting classes can be run. Works fine in SCCM 2007. Anything I can do about it? Can I edit the sms_def.mof manually or make SCCM override this error checking? Does SCCM 2012 remove the ability to merge/union 32 and 64bit registry reads into a single reporting class (that’s been available since SMS 2003?) // :[-Start-AutoLogon Reporting Class-Start-]: #pragma namespace (.\\root\\cimv2\\SMS) #pragma deleteclass(WinLogon, NOFAIL) [SMS_Report(TRUE),SMS_Group_Name(WinLogon),SMS_Class_ID(MICROSOFT|WinLogon|1.0), SMS_Context_1(__ProviderArchitecture=32|uint32), SMS_Context_2(__RequiredArchitecture=true|boolean)] Class WinLogon: SMS_Class_Template { [SMS_Report(TRUE),key] string KeyName; [SMS_Report(FALSE)] String ReportBootOk; [SMS_Report(FALSE)] String Shell; [SMS_Report(FALSE)] String PreCreateKnownFolders; [SMS_Report(FALSE)] String Userinit; [SMS_Report(FALSE)] String VMApplet; [SMS_Report(FALSE)] Uint32 AutoRestartShell; [SMS_Report(FALSE)] String Background; [SMS_Report(FALSE)] String CachedLogonsCount; [SMS_Report(FALSE)] String DebugServerCommand; [SMS_Report(FALSE)] Uint32 ForceUnlockLogon; [SMS_Report(FALSE)] String LegalNoticeCaption; [SMS_Report(FALSE)] String LegalNoticeText; [SMS_Report(FALSE)] Uint32 PasswordExpiryWarning; [SMS_Report(FALSE)] String PowerdownAfterShutdown; [SMS_Report(FALSE)] String ShutdownWithoutLogon; [SMS_Report(FALSE)] String WinStationsDisabled; [SMS_Report(FALSE)] Uint32 DisableCAD; [SMS_Report(FALSE)] String scremoveoption; [SMS_Report(FALSE)] Uint32 ShutdownFlags; [SMS_Report(TRUE)] String AutoAdminLogon; [SMS_Report(TRUE)] String DefaultUserName; [SMS_Report(FALSE)] String DefaultDomainName; [SMS_Report(FALSE)] String
[mssms] RE: Reporting Services Point Installation
Yes, this is normal and is simply the result of ESC and UAC - try hitting it from another system to verify. Also, why would you do 2012 RTM? TO my knowledge, that's not supported anymore. You should at least be doing SP1 and preferably R2. J From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Orlebeck, Geoffrey Sent: Monday, June 2, 2014 4:56 PM To: mssms@lists.myitforum.com Subject: [mssms] Reporting Services Point Installation Hello group, I've got another hopefully simple question. I'm going through the initial install/configuration of Reporting Services and hit something I just want to make sure won't be a roadblock down the road. I was following Niall's documentation at windows-noob for this test install, and at the step after launching IE as Administrator, it's prompting me to authenticate to that URL (http://localserver.domain.org/reports). If I authenticate, the page appears to come up without issue and can perform the subsequent steps. I just don't want to blindly continue if something may be misconfigured and not know it. This server is running IE11 (it's from a VM deployment template I must use), so I am curious if that is the issue? The SCCM install is SCCM2012 (no-SP1), with SQL 2008 R2. Thanks. Confidentiality Notice: This is a transmission from Community Hospital of the Monterey Peninsula. This message and any attached documents may be confidential and contain information protected by state and federal medical privacy statutes. They are intended only for the use of the addressee. If you are not the intended recipient, any disclosure, copying, or distribution of this information is strictly prohibited. If you received this transmission in error, please accept our apologies and notify the sender. Thank you.
RE: [mssms] Mighty MOFin' power rangers
Essentially yes to all your questions. I think there's probably an 'except if...' Somewhere in there, but I can't think of it right now... On June 2, 2014 5:23:09 PM CDT, Miller, Todd todd-mil...@uiowa.edu wrote: So the only time I will have two classes is if I REALLY do want to collect similar data from both the “real” and “redirected” registries – like “Uninstall” key for instance? Otherwise, I leave it all “normal” if I want to read HKLM\Software\BlahBlah on both 32/64bit OS, and if I want to do redirection to the wow6432node I leave in the Providerarchitecture stuff? As long as I want to read either the HKLM\Software OR (not AND) HKLM\Software\wow6432node. I only need one section in sms_def.mof and one section in configuration.mof. and the redirection is turned on/off by the providerarchitecture thing? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger Sent: Monday, June 02, 2014 4:25 To: mssms@lists.myitforum.com Subject: Re: [mssms] Mighty MOFin' power rangers Yeah, it gets complicated/counter-intuitive. Try this and ONLY this as a toBeImport.Mof: #pragma namespace (.\\root\\cimv2\\SMSfile:///\\\root\cimv2\SMS) #pragma deleteclass(WinLogon, NOFAIL) [SMS_Report(TRUE),SMS_Group_Name(WinLogon),SMS_Class_ID(WinLogon)] Class WinLogon: SMS_Class_Template { [SMS_Report(TRUE),key] string KeyName; [SMS_Report(FALSE)] String ReportBootOk; [SMS_Report(FALSE)] String Shell; [SMS_Report(FALSE)] String PreCreateKnownFolders; [SMS_Report(FALSE)] String Userinit; [SMS_Report(FALSE)] String VMApplet; [SMS_Report(FALSE)] Uint32 AutoRestartShell; [SMS_Report(FALSE)] String Background; [SMS_Report(FALSE)] String CachedLogonsCount; [SMS_Report(FALSE)] String DebugServerCommand; [SMS_Report(FALSE)] Uint32 ForceUnlockLogon; [SMS_Report(FALSE)] String LegalNoticeCaption; [SMS_Report(FALSE)] String LegalNoticeText; [SMS_Report(FALSE)] Uint32 PasswordExpiryWarning; [SMS_Report(FALSE)] String PowerdownAfterShutdown; [SMS_Report(FALSE)] String ShutdownWithoutLogon; [SMS_Report(FALSE)] String WinStationsDisabled; [SMS_Report(FALSE)] Uint32 DisableCAD; [SMS_Report(FALSE)] String scremoveoption; [SMS_Report(FALSE)] Uint32 ShutdownFlags; [SMS_Report(TRUE)] String AutoAdminLogon; [SMS_Report(TRUE)] String DefaultUserName; [SMS_Report(FALSE)] String DefaultDomainName; [SMS_Report(FALSE)] String DefaultPassword; [SMS_Report(FALSE)] Uint32 AutoLogonCount; [SMS_Report(FALSE)] Uint32 GpNetworkStartTimeoutPolicyValue; }; From both a 32-bit and a 64-bit OS, confirm that box types report what you think you want that to report. Here's the short answer of why it works: CM12 now is both a 64bit client and a 32bit client. So for this SPECIFIC example, the winlogin regkeys you are looking for aren't in the look elsewhere for 32-bit app information. On both 32 and 64 bit OS... it's in hklm\software\normal... NotTheWin6432node Redirected location if the OS happens to be 64. The answer changes if you ARE looking for 32-bit app information on a 64-bit system. So don't just take the next mof edit and do the exact same thing. That might be the wrong answer for the next custom edit. Oh, and I skipped about 3 steps in my explanation. the real problem is that you are trying to import a cm07 sms_def.mof edit. and cm12 just doesn't get it. It needs to be cm12 to be imported from regkeytomof. You can't just copy/paste from your cm07 mof files straight into cm12... there are subtle changes to any custom mof edits that just don't work in cm12 (as you've seen, the unique class id message) On Monday, June 2, 2014 4:05 PM, Miller, Todd todd-mil...@uiowa.edumailto:todd-mil...@uiowa.edu wrote: I have a problem/question with a MOF edit. I am moving some MOF edits I made from 2007 to 2012 and am running into a little trouble with the ones that have conditional 32/64 components to them. Let’s take Winlogon for example. I collect data from the Winlogon reg key to catch autologon machines. I have the configuration.mof edited and working… but I am running into trouble importing the sms_def.mof when there is conditional statements in the reporting class. When I try to import this into SCCM 2012, it complains that there are duplicates. The importer is not smart enough to know that only one or the other reporting classes can be run. Works fine in SCCM 2007. Anything I can do about it?Can I edit the sms_def.mof manually or make SCCM override this error checking? Does SCCM 2012 remove the ability to merge/union 32 and 64bit registry reads into a single reporting class (that’s been available since SMS 2003?) [cid:image001.png@01CF7E80.D8E90FE0] // :[-Start-AutoLogon Reporting Class-Start-]: #pragma namespace (.\\root\\cimv2\\SMSfile:///\\\root\cimv2\SMS) #pragma deleteclass(WinLogon, NOFAIL) [SMS_Report(TRUE),SMS_Group_Name(WinLogon),SMS_Class_ID(MICROSOFT|WinLogon|1.0), SMS_Context_1(__ProviderArchitecture=32|uint32), SMS_Context_2(__RequiredArchitecture=true|boolean)]
[mssms] (CM07) Moving site database to new server (2003 x86 to 2008R2) and new SQL version (2008 to 2008R2)
Our 32bit Windows 2003 Server housing the site database (SQL 2008) is coming off lease so we need to move it. The DB guys want to move it to a Win2008 R2 server with SQL 2008 R2 on it too. I've never done a site DB move before and have read quite a few How-to's on the interwebs, including the TechNet onehttp://technet.microsoft.com/en-us/library/bb680707.aspx. Most articles seem to be on moving/upgrading from 2005 to 2008 like this one from Windows-noobhttp://www.windows-noob.com/forums/index.php?/topic/693-guide-moving-your-site-database/. Is it the same steps for an SQL 2008 to SQL 2008 R2 migration? Jerry Lai Systems Engineer, Desktop Management Herbert Smith Freehills T +61 3 9288 1780 M +61 4198 9461 F +61 3 9288 1567 www.herbertsmithfreehills.comhttp://www.herbertsmithfreehills.com/ linkedin.com/in/JerryLaiHSFhttp://www.linkedin.com/in/jerrylaihsf Herbert Smith Freehills LLP and its subsidiaries and Herbert Smith Freehills, an Australian Partnership, are separate member firms of the international legal practice known as Herbert Smith Freehills. This message is confidential and may be covered by legal professional privilege. If you are not the intended recipient you must not disclose or use the information contained in it. If you have received this email in error please notify us immediately by return email or by calling our main switchboard on +612 9225 5000 and delete the email. Further information is available from www.herbertsmithfreehills.com.
[mssms] SCCM 2012 R2 cbt
Is there any CBT for ConfigMgr 2012 R2