[mssms] ConfigMgr 2012 SP1: Supported SQL Server Reporting Services (SSRS) Versions

Hey folks, Maybe it's just me, but I don't see any documentation in the Supported Configurations for Configuration Manager TechNet documentation that indicate which versions of SQL Server Reporting Services (SSRS) are supported for int

Re: [mssms] Default report query

Than, if I use that I will leverage RBA for reports, if not I will not have access control to my custom reports. Just that, right? Tnx a lot, 2013/9/18 Garth Jones > The parameter @UserID is not blank, it collects the UserID of the person > running the report. It isn’t do much in CM12 but it w

RE: [mssms] Default report query

The parameter @UserID is not blank, it collects the UserID of the person running the report. It isn't do much in CM12 but it will be used a ton in CM12R2 to leverage RBA within SSRS. I'm working on a whole set of blogs/videos that will give details on how it works and how to create report for RBA i

RE: [mssms] SQL Reporting Services - Benefits of newer versions

Yeah, I'm not debating the longer support, performance, and reliability, but I'm looking for something more concrete that I can take to a customer to persuade them to upgrade to 2012. If there isn't anything, then that's fine. I just was wondering if there were any functional enhancements that I sh

Re: [mssms] Default report query

I got it, tnx. But its a little strange, did you see? this is BLANK parameter. 2013/9/18 Daniel Ratliff > Also check the dataset properties. > > ** ** > > > > ** ** > > *Daniel Ratliff* > > ** ** > > *From:* listsad...@lists.myitforum.com [mailto: > listsad...@lists.myitforum.com] *O

RE: [mssms] Default report query

Also check the dataset properties. [cid:image002.png@01CEB4B3.A740A3A0] Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Wednesday, September 18, 2013 9:08 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Default

RE: [mssms] Default report query

It should be under parameters. [cid:image001.png@01CEB4B3.17012620] Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of JRIT Sent: Wednesday, September 18, 2013 9:02 PM To: mssms@lists.myitforum.com Subject: Re: [mssms] Default report query

Re: [mssms] Default report query

Thank you Daniel, I am analysing a report, this: Computers where physical memory has changed SELECT Distinct SYS.Name0, ROUND(NewMem.TotalPhysicalMemory0,-3) As 'Current Physical Memory (MB)', ROUND(OldMem.TotalPhysicalMemory0, -3) As 'Previous Physical Memory (MB)' >From fn_rbac_R_Syst

RE: [mssms] Default report query

Open the report in report builder then view the dataset query. Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of JRIT Sent: Wednesday, September 18, 2013 8:09 PM To: mssms@lists.myitforum.com Subject: [mssms] Default report query How can I

[mssms] Ideas to Upgrade Telecommuters to Win 7

For remote users who do not come into the office, has anyone come across any novel solutions to address upgrading them from XP to Win 7? Asides from having them ship their laptop, or ship them a DVD/USB, are there any other options? We are on CM 2007. Thanks Andrew

[mssms] Default report query

How can I see/access the query for a Default report in SCCM 2012? Tnx

RE: [mssms] Can anyone explain if not in native mode what the Client Cert is for?

In HTTP client mode, clients use self-signed (self-generated) certs for authentication and signing messages. In HTTPS client mode, these are both valid also as well as transferring content (including policies) securely - this requires PKI generated certs. J From: listsad...@lists.myitforum.com

[mssms] RE: Co-existence of SCCM and SCVMM WDS/PXE server

You won't be able to use the same WDS instance for anything other than ConfigMgr purposes. J From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Robertson, Casey Sent: Wednesday, September 18, 2013 5:55 PM To: mssms@lists.myITforum.com Subject: [mssms] Co-e

[mssms] Co-existence of SCCM and SCVMM WDS/PXE server

Our server deployments are in desperate need of automation including our Hyper-V hosts. I know there is an HP Insight pack for SCCM but to get 2012 deployment capabilities I need the SCCM host to be on 2012 (it's currently on 2008). So since we want to use more Hyper-V and virtualization anywa

RE: [mssms] SQL Reporting Services - Benefits of newer versions

Faster, better, but for sure, certainly longer supported? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sullivan Sent: Mittwoch, 18. September 2013 20:14 To: mssms@lists.myitforum.com Subject: [mssms] SQL Reporting Services - Benefits of new

RE: [mssms] ConfigMgr 2012 SP1 Console Connection Limit

Remote assistance is so much easier for users to connect to each other. Even service desk can use it. Not good enough for you? -R From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Eric Morrison Sent: Mittwoch, 18. September 2013 19:46 To: mssms@li

[mssms] Can anyone explain if not in native mode what the Client Cert is for?

I have been looking for the answers an maybe im just missing it, but what benefit does the Client Certificate give if you do not have a PKI and are running in HTTP mode on SCCM? Does it bring anything in the way of securing your connections? Is it for Internet Based Clients? I'm looking to eve

Re: [mssms] Bitlocker - Determine if the bitlocker partition is created

to test the script try pxe booting into winPE and run the script while in winpe after a *use toolkit package* step (you can pause the task sequence to make it easier) see here

RE: [mssms] Bitlocker - Determine if the bitlocker partition is created

Yes, I have the ZTIUtility.vbs script in the same folder as the Bitlocker_Partition.WSF file. I did what you stated with removing the ..\ and I'm still receiving the same error. I copied the two files (ZTIUtility.vbs & Bitlocker_Partition.WSF ) to my local drive to test and I'm receiving the sa

Re: [mssms] Add ip subnets script

Yes 2007, and eventually 2012, but not right now. This is sort of a prep for 2012. On Wed, Sep 18, 2013 at 12:56 PM, Trevor Sullivan wrote: > So, I’m assuming that we’re talking about ConfigMgr 2007, since you’re > using the term “BDP?” > > ** ** > > If your environment is that large, as

RE: [mssms] Add ip subnets script

So, I'm assuming that we're talking about ConfigMgr 2007, since you're using the term "BDP?" If your environment is that large, as to need a total sum of 30k boundaries . have you reconsidered the use of BDPs? How about upgrading to ConfigMgr 2012 (which makes scripting boundaries MUCH easier)?

[mssms] Add ip subnets script

I have 15k+ ad sites as protected boundaries to BDP's, and need to add 15k+ Ip subnets to those protected boundaries of these existing BDP's Has anyone made a script that would add or switch this? Thanks!

Re: [mssms] Bitlocker - Determine if the bitlocker partition is created

is the script in the same folder or different folder as the mdt scripts folder as the ztiutility script is referenced on line 2?, the ..\ in front of ZTIUtility will decide that (by adding or removing extra ..\..\) so if you have the script in a subfolder of MDT scripts such as scripts\customscri

[mssms] Bitlocker - Determine if the bitlocker partition is created

Guys, I'm trying to figure out if the Bitlocker partition is created because we're having to deploy Bitlocker to 2000 systems and some may have the Bitlocker partition while others may not have the partition created. When trying to run the script created by Niall at http://www.niallbrady.com/20

RE: [mssms] SQL Reporting Services - Benefits of newer versions

Most of the revisions are centered on integration with SharePoint and PowerPivot... http://technet.microsoft.com/en-us/library/ms170438.aspx My advice, if you have the option, use SQL 2012. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sulliva

[mssms] SQL Reporting Services - Benefits of newer versions

Hey folks, I'm really not a "SQL guy," so I'll pose this question to those of you who are. Are there any significant benefits of going with SQL Server Reporting Services 2012 SP1 instead of using SSRS 2008 R2 SP2? Cheers, Trevor Sullivan

Re: [mssms] ConfigMgr 2012 SP1 Console Connection Limit

If it were my choice, I wouldn't give the console to people who just need to use remote control. If you need to audit, there's potentially this:  http://myitforum.com/cs2/blogs/jgilbert/archive/2007/08/08/inventorying-remote-assistance-requests-and-connections.aspx   May or may not work dependin

RE: [mssms] ConfigMgr 2012 SP1 Console Connection Limit

I "think" there's a way to audit even if you are not launching the session from the console but I am not sure. I seem to recall reading a blog about how to do that once. I don't think that there is a limit on concurrent sessions but I would not suggest deploying that many consoles. Keeping them

[mssms] ConfigMgr 2012 SP1 Console Connection Limit

Hello Everyone, I'm currently at a client doing a ConfigMgr 2007 to ConfigMgr 2012 SP1 migration. Currently in their 2007 environment, they use the built-in remote control features of ConfigMgr to connect to different machines throughout the organization for support scenarios and different test

Re: [mssms] MS load balance

Front End Server = Management Server. in SCOM a MS have load balancing by design, in SCSM I need to use NLB to do that. The question is, WHY? 2013/9/18 > What are you load balancing? The data warehouse server or the front end > server? > > ** ** > > *Christopher Catlett* > > Consultant |

RE: [mssms] SCCM 2012 CU2 upgrade to SCCM 2012 R2

Right. But since R2 is a preview, there is no way to know that before RTM. -R From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of christopher.catl...@us.sogeti.com Sent: Mittwoch, 18. September 2013 17:44 To: mssms@lists.myitforum.com Subject: RE: [m

RE: [mssms] CM12 CU2 unattended?

Nope, still presents the same wizard, nothing else. So, it has to be the large MSI in there if there is any chance. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Roland Janus Sent: Mittwoch, 18. September 2013 17:45 To: mssms@lists.myitforum.com S

[mssms] OT: powershell and disjoined machines

http://windowsitpro.com/blog/quick-fix-computers-no-longer-domain-joined Pretty cool

RE: [mssms] mdt & drivergroup

nothing wrong with the nic it goes on to load the wim image... Stuart Watret Offshore - IT Ltd From: listsad...@lists.myitforum.com [listsad...@lists.myitforum.com] on behalf of Ryan [ryan2...@gmail.com] Sent: 18 September 2013 14:47 To: mssms@lists.myitfo

RE: [mssms] CM12 CU2 unattended?

I'll try that. I was expecting the kb.exe to have switches, but maybe it is just the setup.exe From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sullivan Sent: Mittwoch, 18. September 2013 17:36 To: mssms@lists.myitforum.com Subject: RE: [

RE: [mssms] SCCM 2012 CU2 upgrade to SCCM 2012 R2

Yes, but MS has not said if CU2 is required for the upgrade. I might not be if the R2 upgrade replaces the stuff that CU2 fixes. Christopher Catlett Consultant | Detroit [MCTS_2013_small] Sogeti USA Office 248-876-9738 |Fax 877.406.9647 26957 Northwestern Highway, Suite 130, Southfield, MI 48033

Re: [mssms] ConfigMgr 2012 & Riverbed

In my case, I believe I had to request "bypass mode" based on source/destination IP pairing. On Wed, Sep 18, 2013 at 7:33 AM, Trevor Sullivan wrote: > Thanks guys. Is there a way to configure the Riverbed devices to ignore > traffic to/from ConfigMgr site systems? I’m not familiar with the > co

RE: [mssms] CM12 CU2 unattended?

Here's what I'm seeing in 7-Zip for Cumulative Update #2 for Configuration Manager 2012 with Service Pack 1. Can you call updatesetup.exe with /? to see if it has built-in help? Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On

RE: [mssms] SCCM 2012 CU2 upgrade to SCCM 2012 R2

CU2 updates many components after SP1. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of christopher.catl...@us.sogeti.com Sent: Mittwoch, 18. September 2013 17:26 To: mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012 CU2 upgrade to SCCM 2012 R2

RE: [mssms] ConfigMgr 2012 & Riverbed

By source/target IP, probably also be ports. Shouldn't be a problem -R From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sullivan Sent: Mittwoch, 18. September 2013 16:34 To: mssms@lists.myitforum.com Subject: RE: [mssms] ConfigMgr 2012 & Rive

RE: [mssms] CM12 CU2 unattended?

Looks like not supported like this. J Certainly they should provide that for any CU if that is the only update method. -R From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trond Karstensen Sent: Mittwoch, 18. September 2013 14:45 To: mssms@lists.myit

[mssms] RE: Image for windows 8

Please look at the guides for Windows 8, Windows 8.1 will be the same. If you have a specific question, please start a new thread. Christopher Catlett Consultant | Detroit [MCTS_2013_small] Sogeti USA Office 248-876-9738 |Fax 877.406.9647 26957 Northwestern Highway, Suite 130, Southfield, MI 480

RE: [mssms] CM12 CU2 unattended?

Did that, well just start it and look into the extraction folder, found setup.exe (large) and one MSI in there. Hm, maybe the setup.exe also extracts? -R From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sullivan Sent: Mittwoch, 18. Sept

RE: [mssms] CM12 CU2 unattended?

Not the client Sherry, the complete installation with options what I want, update site server, console, having the upgrade packages created etc. I can install the server unattended but the CUs not at all? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On B

Re: [mssms] SCCM 2012 CU2 upgrade to SCCM 2012 R2

>From Technet: http://technet.microsoft.com/en-us/library/jj822981.aspx#BKMK_UpgradeR2Considerations "Configuration Manager supports installing System Center 2012 R2 Configuration Manager to upgrade a site that runs Configuration Manager SP1" Also here: http://technet.microsoft.com/en-us/library/

RE: [mssms] SCCM 2012 CU2 upgrade to SCCM 2012 R2

You must be on SP1, not sure if SP1 CU2 is required. Christopher Catlett Consultant | Detroit [MCTS_2013_small] Sogeti USA Office 248-876-9738 |Fax 877.406.9647 26957 Northwestern Highway, Suite 130, Southfield, MI 48033-8456 www.us.sogeti.com From: listsad...@lists.my

RE: [mssms] mdt & drivergroup

Another way would be to use a separate driver step in the TS, and filter with the wmi query. I'll be diving into HP and Lenovo drivers shortly at my present client. I MISS DELL!! Warren, you guys are the best. Christopher Catlett Consultant | Detroit [MCTS_2013_small] Sogeti USA Office 248

RE: [mssms] SCCM 2012 CU2 upgrade to SCCM 2012 R2

>From >http://technet.microsoft.com/en-us/library/jj822981.aspx#BKMK_PlanningR2Upgrade: "Configuration Manager supports installing System Center 2012 R2 Configuration Manager to upgrade a site that runs Configuration Manager SP1. You can run the upgrade on the site servers of central administra

RE: [mssms] MS load balance

What are you load balancing? The data warehouse server or the front end server? Christopher Catlett Consultant | Detroit [MCTS_2013_small] Sogeti USA Office 248-876-9738 |Fax 877.406.9647 26957 Northwestern Highway, Suite 130, Southfield, MI 48033-8456 www.us.sogeti.com

[mssms] SCCM 2012 CU2 upgrade to SCCM 2012 R2

Hello, It is possible to upgrade directly from SCCM 2012 CU2 to SCCM 2012 R2 ? Or do I need to install SP1 first and then upgrade to R2. Thanks. Regards.

RE: [mssms] ConfigMgr 2012 & Riverbed

Thanks guys. Is there a way to configure the Riverbed devices to ignore traffic to/from ConfigMgr site systems? I'm not familiar with the configuration of these devices, so any insight would be appreciated. Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com [mailto:listsad...@lis

Re: [mssms] mdt & drivergroup

I'm more of a fan of HP's bleh line myself. Are you sure the correct drivers are in PE for the NIC? On Wed, Sep 18, 2013 at 8:41 AM, Stuart Watret wrote: > implemented drivergroup entries in my mdt the other day to get specific > machines to use certain drivers. > > > > this worked well by ad

[mssms] mdt & drivergroup

implemented drivergroup entries in my mdt the other day to get specific machines to use certain drivers. this worked well by adding the line to the rules tab like this: [HP blah blah 8440b] drivergroup0001=path blah blah driver selectionprofile=nothing This was working well until I trie

RE: [mssms] Image for windows 8

I see what you did there From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Niall Brady Sent: Wednesday, September 18, 2013 9:15 AM To: mssms@lists.myitforum.com Subject: Re: [mssms] Image for windows 8 "I'm can i able to do on SCCM 2012 SP1?" nope, you ne

RE: [mssms] Image for windows 8

Not until CU3 for SP1 is released: http://blogs.technet.com/b/configmgrteam/archive/2013/09/16/support-questions-about-win-8.1-and-winsvr-2012-r2-for-configmgr-and-endpoint-protection.aspx J -Original Message- From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] O

Re: [mssms] Image for windows 8

"I'm can i able to do on SCCM 2012 SP1?" nope, you need to wait for R2 to get support for deploying Windows 8.1 cheers niall On Wed, Sep 18, 2013 at 2:51 PM, Syed Lateef wrote: > Hi, > > I'm can i able to do on SCCM 2012 SP1? > > > Regards, > Syed Lateef > IT Support Administrator, ENDP > KH

RE: [mssms] CM12 CU2 unattended?

I don't have it in front of me at the moment, but I believe you can extract the appropriate bits with 7-Zip, from the CU2 download, and make it silent that way. They should be MSI or MSP files, if I recall correctly. Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com [mailto:list

RE: [mssms] Image for windows 8

Hi, I'm can i able to do on SCCM 2012 SP1? Regards, Syed Lateef IT Support Administrator, ENDP KHDA From: listsad...@lists.myitforum.com [listsad...@lists.myitforum.com] on behalf of Johns, Damon (DoJ) [damon.jo...@justice.tas.gov.au] Sent: Wednesday,

RE: [mssms] CM12 CU2 unattended?

I've asked the same question, but did not get any good answers. This will install the update bits: cmd /c msiexec /i \CM12\SP1CU2\cm12-sp1cu2-kb2854009-x64-enu.msi /qb! cmd /c msiexec /p \CM12\hotfix\KB2854009\AdminConsole\i386\configmgr2012adminui-sp1-kb2854009-i386.msp /qb! Then you have to r

Re: [mssms] CM12 CU2 unattended?

If this is for clients, the CU2 install process on your server gives the option to create update packages. You can then deploy them to collections. Or looking at the package would give you the install string. Jeff On Sep 18, 2013 6:57 AM, "Roland Janus" wrote: > Is there a way? > > It does

Re: [mssms] CM12 CU2 unattended?

Do you have SCUP installed?  Did you import the scup.cab from \CM\hotfix\\scup We just send out the CU2 via Software Updates (with SCUP, + the SCUP cert on the clients, of course)   Sherry Kissinger Microsoft MVP - ConfigMgr mofmas...@myitforum.com From: Rola

[mssms] CM12 CU2 unattended?

Is there a way? It doesn't show parameters (with /?) and I couldn't find anything online yet.

[mssms] MS load balance

I need I use NLB to load balance between MS in SCSM?? AFAIK SCSM is based on SCOM, and SCOM 2012 have load balance between MS without NLB :) Regards,

RE: [mssms] CM12, Reporting Point on remote box

Well, I have another reason to move reporting: I do expect heavy use of automation, so I want to have another sms provider (I also do that for the two primaries, but use the remote SQL box for that). Now, with the CAS and SQL on the same server, there is no server left. I'd rather not just mo

AW: [mssms] CM12, Reporting Point on remote box

I recently installed a SMSProv and CM DB on the same server then installed the reporting DB on a separate instance on this same server, with the SSRS instance and the reportng services point on a separate server. This was due to customer requirements, and their SQL standards. The SSRS instance

Re: [mssms] Image for windows 8

And dont forget to use all the new deployment tools to configure your win 8.1 environment like the new group policy items and the new tool that lets you capture and deploy a default live tile layout for all users. Original message From: Niall Brady Date: To: mssms@lists.myit

Re: [mssms] Image for windows 8

Step 1. wait for System Center 2012 Configuration Manager R2 to release (GA is approximately October 18th). Step 2. Install R2 and any prerequisites as described below:- - CM12 in a Lab - How can I deploy Windows 8.1 using System Center 2012 R2 Configuration Manager ?

[mssms] Image for windows 8

Dear All, I want to create an image on SCCM 2012 for Windows 8.1 . Kindly send me the steps with images that I can follow to create image in SCCM 2012 with task sequence Your inputs are highly appreciated. Regards, Syed Lateef سيد لطيف Senior IT Support Administrator إداري أول دعم تقين