[mssms] SCCM 2012 R2 cbt

Is there any CBT for ConfigMgr 2012 R2

[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 th

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" wrote: >So the only time I will have two classes is if I REALLY do want to >collect similar data from both th

[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

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_Rep

[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 machine

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 an

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

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

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

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

[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 wrote: > Please disregard. Problem has been resolved. > > Thanks, > > > > On Mon, Jun

[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 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 fun

[mssms] ConfigMgr 2012 Cloud Distribution Point affected?

The Microsoft Azure platform is retiring Windows Server 2008 Service Pack 2 (SP2) as a guest operating system. When you install a Cloud Distribution Point in Configuration Manager 2012 R2, the operating system used by the guest instances is Windows Server 2008 SP2. Will the ConfigMgr 2012 R2 Cl

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 procedure

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 jus

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: slk

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

[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 "Po

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" Sent: June 2, 2014 8:57 PM

[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 r

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 nee

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

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. My

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.com | www.1e.com Facebook

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:l

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" wrote: > > Do you actually have “multiple install” steps in the TS? > The i

[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 tha