[mssms] moving to CM2012..
Hi all, Has anyone put together any presentations to the benefits of moving to CM2012, were starting to put our case forward, just wanted to avoid re-inventing the wheel. Apart from, its the best thing since sliced bread and you wont regret it :) Thanks, Ricky.
RE: [mssms] moving to CM2012..
I believe Wally has something to say on the advantages and benefits... http://info.bdna.com/20111207-Webcast-SCCM-Guru-Wally-Mead-ReplayRegistrationPage.html From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Rickym61 Sent: 24 January 2014 10:50 To: mssms@lists.myitforum.com Subject: [mssms] moving to CM2012.. Hi all, Has anyone put together any presentations to the benefits of moving to CM2012, were starting to put our case forward, just wanted to avoid re-inventing the wheel. Apart from, its the best thing since sliced bread and you wont regret it :) Thanks, Ricky.
[mssms] IE10 and the Troubles of Deploying via SCCM
Hello, I have seen a few e-mails and posts on the net so I wanted to check with the experts :) Over the past few weeks I have been trying to deploy Internet Explorer 10 to Windows 7 (running IE8). Simple Well not so.. I am attempting to deploy via SCCM 2007 R2, by 2 ways.. by a standard EXE and also via WSUS. I have created an EXE via the IEAK and for some this works and for other workstations this fails. Reviewing deeper there a few pre-reqs required. I am still experiencing issues with this and wanted to know if anyone can advise on their experiences to get IE10 deployed (ideally I would prefer to use SCCM and WSUS than the IEAK). Any tips or tricks of the trade would be greatly appreciated. Regards, Tony This email and any attachments are confidential and may also contain copyright material of the Lend Lease Group. If you are not the intended recipient, please notify us immediately and delete all copies of this message. You must not copy, use, disclose, distribute or rely on the information contained in it. Copying or use of this communication or information in it is strictly prohibited and may be unlawful. Contracts cannot be concluded with the Lend Lease Group nor service effected by email. None of the staff of the Lend Lease Group are authorised to enter into contracts on behalf of any member of the Lend Lease Group in this manner. The fact that this communication is in electronic form does not constitute our consent to conduct transactions by electronic means or to use or accept electronic records or electronic signatures. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken delivery to you. Lend Lease does not guarantee that this email or the attachment(s) are unaffected by computer virus, corruption or other defects and accepts no liability for any damage caused by this email or its attachments due to viruses, interception, corruption or unauthorised access. Lend Lease Group may monitor email traffic data and also the content of email for the purposes of security and staff training. Please note that our servers may not be located in your country. A list of Lend Lease Group entities can be found at http://www.lendlease.com/OperatingEntities
[mssms] Cannot insert duplicate key in object 'dbo.PkgStatus_G'.
Hi all, Receiving this error on one of the secondary sites in the hierarchy. Not much appearing in the way of Google hits for this, other than possibly updating the DB, unsupported of course. The key does already exist in the DB, but I'm not sure why it's only happening for this particular package on this particular secondary. All other secondaries and all other packages are fine. SCCM 2012 R2, and the Secondary has SQL Server 2012 SP1 installed, like all the other Secondary Site servers. I've tried all the simple ones like refreshing package, removing package from site, wait a day, reapply, as well as rebooting, and even using extractcontent.exe, but so far nothing has worked. Any ideas? Cheers.
[mssms] RE: IE10 and the Troubles of Deploying via SCCM
I've created x86 and x64 msi's using the IEAK and am deploying them via CM 2012 currently without issue, although we are still quite early in the testing process. IEAK should generate an msi in the same directory it generated the exe - have you tried using that? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Lawrence, Tony Sent: Friday, January 24, 2014 7:46 AM To: mssms@lists.myitforum.com Subject: [mssms] IE10 and the Troubles of Deploying via SCCM Hello, I have seen a few e-mails and posts on the net so I wanted to check with the experts :) Over the past few weeks I have been trying to deploy Internet Explorer 10 to Windows 7 (running IE8). Simple Well not so.. I am attempting to deploy via SCCM 2007 R2, by 2 ways.. by a standard EXE and also via WSUS. I have created an EXE via the IEAK and for some this works and for other workstations this fails. Reviewing deeper there a few pre-reqs required. I am still experiencing issues with this and wanted to know if anyone can advise on their experiences to get IE10 deployed (ideally I would prefer to use SCCM and WSUS than the IEAK). Any tips or tricks of the trade would be greatly appreciated. Regards, Tony This email and any attachments are confidential and may also contain copyright material of the Lend Lease Group. If you are not the intended recipient, please notify us immediately and delete all copies of this message. You must not copy, use, disclose, distribute or rely on the information contained in it. Copying or use of this communication or information in it is strictly prohibited and may be unlawful. Contracts cannot be concluded with the Lend Lease Group nor service effected by email. None of the staff of the Lend Lease Group are authorised to enter into contracts on behalf of any member of the Lend Lease Group in this manner. The fact that this communication is in electronic form does not constitute our consent to conduct transactions by electronic means or to use or accept electronic records or electronic signatures. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken delivery to you. Lend Lease does not guarantee that this email or the attachment(s) are unaffected by computer virus, corruption or other defects and accepts no liability for any damage caused by this email or its attachments due to viruses, interception, corruption or unauthorised access. Lend Lease Group may monitor email traffic data and also the content of email for the purposes of security and staff training. Please note that our servers may not be located in your country. A list of Lend Lease Group entities can be found at http://www.lendlease.com/OperatingEntities This e-mail is intended only for the person or entity to whom it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of this message is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the original message and all copies from your system. Statements and representations made in this message are not necessarily that of the Company.
[mssms] Upgrade server 2012 to R2
Hallo, Just a question, did anybody do an upgrade from Windows server 2012 to windows server 2012 R2 by deployment with SCCM 2012? Is it even possible? Mario
[mssms] RE: IE10 and the Troubles of Deploying via SCCM
Thanks for the reply, I have tried the MSI as well with mix results. As part of your deployment are you installing any updates beforehand or just deploying the IE10 msi? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of andrew.ber...@everestre.com Sent: Friday, January 24, 2014 8:03 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: IE10 and the Troubles of Deploying via SCCM I've created x86 and x64 msi's using the IEAK and am deploying them via CM 2012 currently without issue, although we are still quite early in the testing process. IEAK should generate an msi in the same directory it generated the exe - have you tried using that? From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Lawrence, Tony Sent: Friday, January 24, 2014 7:46 AM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] IE10 and the Troubles of Deploying via SCCM Hello, I have seen a few e-mails and posts on the net so I wanted to check with the experts :) Over the past few weeks I have been trying to deploy Internet Explorer 10 to Windows 7 (running IE8). Simple Well not so.. I am attempting to deploy via SCCM 2007 R2, by 2 ways.. by a standard EXE and also via WSUS. I have created an EXE via the IEAK and for some this works and for other workstations this fails. Reviewing deeper there a few pre-reqs required. I am still experiencing issues with this and wanted to know if anyone can advise on their experiences to get IE10 deployed (ideally I would prefer to use SCCM and WSUS than the IEAK). Any tips or tricks of the trade would be greatly appreciated. Regards, Tony This email and any attachments are confidential and may also contain copyright material of the Lend Lease Group. If you are not the intended recipient, please notify us immediately and delete all copies of this message. You must not copy, use, disclose, distribute or rely on the information contained in it. Copying or use of this communication or information in it is strictly prohibited and may be unlawful. Contracts cannot be concluded with the Lend Lease Group nor service effected by email. None of the staff of the Lend Lease Group are authorised to enter into contracts on behalf of any member of the Lend Lease Group in this manner. The fact that this communication is in electronic form does not constitute our consent to conduct transactions by electronic means or to use or accept electronic records or electronic signatures. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken delivery to you. Lend Lease does not guarantee that this email or the attachment(s) are unaffected by computer virus, corruption or other defects and accepts no liability for any damage caused by this email or its attachments due to viruses, interception, corruption or unauthorised access. Lend Lease Group may monitor email traffic data and also the content of email for the purposes of security and staff training. Please note that our servers may not be located in your country. A list of Lend Lease Group entities can be found at http://www.lendlease.com/OperatingEntities This e-mail is intended only for the person or entity to whom it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of this message is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the original message and all copies from your system. Statements and representations made in this message are not necessarily that of the Company. This email and any attachments are confidential and may also contain copyright material of the Lend Lease Group. If you are not the intended recipient, please notify us immediately and delete all copies of this message. You must not copy, use, disclose, distribute or rely on the information contained in it. Copying or use of this communication or information in it is strictly prohibited and may be unlawful. Contracts cannot be concluded with the Lend Lease Group nor service effected by email. None of the staff of the Lend Lease Group are authorised to enter into contracts on behalf of any member of the Lend Lease Group in this manner. The fact that this communication is in electronic form does not constitute our consent to conduct transactions by electronic means or to use or accept electronic records or electronic signatures. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken
[mssms] RE: IE10 and the Troubles of Deploying via SCCM
I found that I had all but one prereq already deployed. The offending prereq was KB2670838 which requires that you enable Feature Packs in Classifications to pick it up through WSUS. I was then able to deploy IE10 through WSUS. I tried IEAK but didn't like the results. Mike From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Lawrence, Tony Sent: Friday, January 24, 2014 7:32 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: IE10 and the Troubles of Deploying via SCCM Thanks for the reply, I have tried the MSI as well with mix results. As part of your deployment are you installing any updates beforehand or just deploying the IE10 msi? From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of andrew.ber...@everestre.commailto:andrew.ber...@everestre.com Sent: Friday, January 24, 2014 8:03 AM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] RE: IE10 and the Troubles of Deploying via SCCM I've created x86 and x64 msi's using the IEAK and am deploying them via CM 2012 currently without issue, although we are still quite early in the testing process. IEAK should generate an msi in the same directory it generated the exe - have you tried using that? From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Lawrence, Tony Sent: Friday, January 24, 2014 7:46 AM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] IE10 and the Troubles of Deploying via SCCM Hello, I have seen a few e-mails and posts on the net so I wanted to check with the experts :) Over the past few weeks I have been trying to deploy Internet Explorer 10 to Windows 7 (running IE8). Simple Well not so.. I am attempting to deploy via SCCM 2007 R2, by 2 ways.. by a standard EXE and also via WSUS. I have created an EXE via the IEAK and for some this works and for other workstations this fails. Reviewing deeper there a few pre-reqs required. I am still experiencing issues with this and wanted to know if anyone can advise on their experiences to get IE10 deployed (ideally I would prefer to use SCCM and WSUS than the IEAK). Any tips or tricks of the trade would be greatly appreciated. Regards, Tony This email and any attachments are confidential and may also contain copyright material of the Lend Lease Group. If you are not the intended recipient, please notify us immediately and delete all copies of this message. You must not copy, use, disclose, distribute or rely on the information contained in it. Copying or use of this communication or information in it is strictly prohibited and may be unlawful. Contracts cannot be concluded with the Lend Lease Group nor service effected by email. None of the staff of the Lend Lease Group are authorised to enter into contracts on behalf of any member of the Lend Lease Group in this manner. The fact that this communication is in electronic form does not constitute our consent to conduct transactions by electronic means or to use or accept electronic records or electronic signatures. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken delivery to you. Lend Lease does not guarantee that this email or the attachment(s) are unaffected by computer virus, corruption or other defects and accepts no liability for any damage caused by this email or its attachments due to viruses, interception, corruption or unauthorised access. Lend Lease Group may monitor email traffic data and also the content of email for the purposes of security and staff training. Please note that our servers may not be located in your country. A list of Lend Lease Group entities can be found at http://www.lendlease.com/OperatingEntities This e-mail is intended only for the person or entity to whom it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of this message is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the original message and all copies from your system. Statements and representations made in this message are not necessarily that of the Company. This email and any attachments are confidential and may also contain copyright material of the Lend Lease Group. If you are not the intended recipient, please notify us immediately and delete all copies of this message. You must not copy, use, disclose, distribute or rely on the information contained in it. Copying or use of this
[mssms] RE: IE10 and the Troubles of Deploying via SCCM
http://myitforum.com/myitforumwp/2013/03/16/deploying-ie10-prereqs-for-win7sp1-with-configmgr-2012/ IE10 prereqs were a giant PITA. The above is for CM2012, but the same principle applies as far as publishing the prereqs to WSUS to make them available in ConfigMgr. Hope that helps! -Phil _ Phil Schwan | Technical Specialist, Enterprise Windows Services Project Leadership Associates | 2000 Town Center, Suite 1900, Southfield, MI 48075 Lync: 312.756.1626 Mobile: 419.262.5133 www.projectleadership.nethttp://www.projectleadership.net/ [Description: Description: Description: Arrow email]Lead with Strategy. Leverage Technology. Deliver Results. [linkedin_logo-19x20]http://www.linkedin.com/in/philschwan[Twitter-Logo1-20x20]https://twitter.com/philschwan [wordpress-logo3] http://myitforum.com/myitforumwp/author/philschwan From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Lawrence, Tony Sent: Friday, January 24, 2014 7:46 AM To: mssms@lists.myitforum.com Subject: [mssms] IE10 and the Troubles of Deploying via SCCM Hello, I have seen a few e-mails and posts on the net so I wanted to check with the experts :) Over the past few weeks I have been trying to deploy Internet Explorer 10 to Windows 7 (running IE8). Simple Well not so.. I am attempting to deploy via SCCM 2007 R2, by 2 ways.. by a standard EXE and also via WSUS. I have created an EXE via the IEAK and for some this works and for other workstations this fails. Reviewing deeper there a few pre-reqs required. I am still experiencing issues with this and wanted to know if anyone can advise on their experiences to get IE10 deployed (ideally I would prefer to use SCCM and WSUS than the IEAK). Any tips or tricks of the trade would be greatly appreciated. Regards, Tony This email and any attachments are confidential and may also contain copyright material of the Lend Lease Group. If you are not the intended recipient, please notify us immediately and delete all copies of this message. You must not copy, use, disclose, distribute or rely on the information contained in it. Copying or use of this communication or information in it is strictly prohibited and may be unlawful. Contracts cannot be concluded with the Lend Lease Group nor service effected by email. None of the staff of the Lend Lease Group are authorised to enter into contracts on behalf of any member of the Lend Lease Group in this manner. The fact that this communication is in electronic form does not constitute our consent to conduct transactions by electronic means or to use or accept electronic records or electronic signatures. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken delivery to you. Lend Lease does not guarantee that this email or the attachment(s) are unaffected by computer virus, corruption or other defects and accepts no liability for any damage caused by this email or its attachments due to viruses, interception, corruption or unauthorised access. Lend Lease Group may monitor email traffic data and also the content of email for the purposes of security and staff training. Please note that our servers may not be located in your country. A list of Lend Lease Group entities can be found at http://www.lendlease.com/OperatingEntities PRIVILEGED AND CONFIDENTIAL. This email and any files transmitted with it are privileged and confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. If you are not the named addressee you should not disseminate, distribute or copy this e-mail or any of its attachments. inline: image001.jpginline: image002.jpginline: image003.jpginline: image004.jpg
RE: [mssms] SCCM 2012, PKI and ICBM
Discussing this with my counterpart now. No, we do not have a PKI infrastructure. I came across this recently. There may be other sources out there but this does seem fairly straight forward. http://blogs.msdn.com/b/scstr/archive/2012/05/31/step_2d00_by_2d00_step_2d00_example_2d00_deployment_2d00_of_2d00_the_2d00_pki_2d00_certificates_2d00_for_2d00_configuration_2d00_manager_2d00_2012_2d00_windows_2d00_server_2d00_2008.aspx I'm entirely new to PKI, so any direction would be nice. Thanks, Brian From: eric.morri...@hotmail.com To: mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM Date: Wed, 22 Jan 2014 09:29:09 -0600 Setting up IBCM in 2012 is a breeze compared to the 2007 days. I’ve configured IBCM in both versions and as long as you have basic PKI understanding, you shouldn’t have too many roadblocks. In the environment you are going to use to set it up, do you already have PKI setup with machine certificates deployed, specifically workstations to be managed over the internet? You’ll also need to either stand up a new site system server in your DMZ, or have the ports reverse proxy to your primary site server. If you’re going to do Software Distribution, Software Updates, and App Catalog, then you’ll need to make sure those roles are setup as HTTPS and the appropriate web server cert in IIS and make sure the roles allow intranet and internet. After that it’s just a matter of making sure the clients have the public fqdn configured for IBCM and that the firewall ports are open. Now, if DA is the option like so many suggested, definitely go that route… J Thanks, Eric Morrison From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, January 21, 2014 2:52 PM To: mssms@lists.myitforum.com; mssms@lists.myitforum.com Subject: [mssms] SCCM 2012, PKI and ICBM Hey everyone, Just out of curiosity, how many hours would you estimate it would take to setup a PKI infrastructure and ICBM for SCCM 2012 R2? My boss has asked me to implement and I have no idea what to guestimate for hours. Looking for someone who has experience with implementing both PKI and ICBM that might be able to give me a rough idea of how many hours this would take. From what I've read ICBM is complex to setup, but that was back in CM07. Not sure how much has changed with CM12. Thanks, Brian
RE: [mssms] Re: [MDT-OSD] SCCM Imaging opening at General Mills.
I don't think the position itself requires a degree or should require a degree. However, some companies have HR requirements that say certain types of positions within a company, require degrees. Michael Dzikowski Senior Systems Engineer | Ally Technical Infrastructure - Windows Hosting [cid:image002.gif@01CDF887.776259A0] From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jimmy Martin Sent: Thursday, January 23, 2014 4:19 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Re: [MDT-OSD] SCCM Imaging opening at General Mills. I grew into my position too... degree in respiratory therapy :) but always a geek at heart From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Rickym61 Sent: Thursday, January 23, 2014 3:13 PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] Re: [MDT-OSD] SCCM Imaging opening at General Mills. Just curious why do most SCCM jobs require some form of degree? Surely there are quite a few SCCM/CM admins (senior/junior) ones out there without a degree, doesn't experience in the role count more than a degree? On Thursday, 23 January 2014, Richard Zuraff richard.zur...@genmills.commailto:richard.zur...@genmills.com wrote: We have an opening for a SCCM Imaging expert in Minneapolis, MN here at General Mills, Inc. If you know anyone that is qualified and looking, please pass along. http://jobs.generalmills.com/minneapolis/experienced/jobid4771117-image-management-technician-sccm-jobs Thanks This message and any files transmitted with it may contain legally privileged, confidential, or proprietary information. If you are not the intended recipient of this message, you are not permitted to use, copy, or forward it, in whole or in part without the express consent of the sender. Please notify the sender of the error by reply email, disregard the foregoing messages, and delete it immediately. P Please consider the environment before printing this email... inline: image001.png
RE: [mssms] SCCM 2012, PKI and ICBM
What about Windows Intune fitting into the discussion as a possible solution? This would get us what we need (Patch Deployment, Compliance Management, Software Deployment). This gives us the same ability to manage internet clients all from a single pane in CM12. From: mcdonald...@hotmail.com To: mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM Date: Fri, 24 Jan 2014 09:04:55 -0600 Discussing this with my counterpart now. No, we do not have a PKI infrastructure. I came across this recently. There may be other sources out there but this does seem fairly straight forward. http://blogs.msdn.com/b/scstr/archive/2012/05/31/step_2d00_by_2d00_step_2d00_example_2d00_deployment_2d00_of_2d00_the_2d00_pki_2d00_certificates_2d00_for_2d00_configuration_2d00_manager_2d00_2012_2d00_windows_2d00_server_2d00_2008.aspx I'm entirely new to PKI, so any direction would be nice. Thanks, Brian From: eric.morri...@hotmail.com To: mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM Date: Wed, 22 Jan 2014 09:29:09 -0600 Setting up IBCM in 2012 is a breeze compared to the 2007 days. I’ve configured IBCM in both versions and as long as you have basic PKI understanding, you shouldn’t have too many roadblocks. In the environment you are going to use to set it up, do you already have PKI setup with machine certificates deployed, specifically workstations to be managed over the internet? You’ll also need to either stand up a new site system server in your DMZ, or have the ports reverse proxy to your primary site server. If you’re going to do Software Distribution, Software Updates, and App Catalog, then you’ll need to make sure those roles are setup as HTTPS and the appropriate web server cert in IIS and make sure the roles allow intranet and internet. After that it’s just a matter of making sure the clients have the public fqdn configured for IBCM and that the firewall ports are open. Now, if DA is the option like so many suggested, definitely go that route… J Thanks, Eric Morrison From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, January 21, 2014 2:52 PM To: mssms@lists.myitforum.com; mssms@lists.myitforum.com Subject: [mssms] SCCM 2012, PKI and ICBM Hey everyone, Just out of curiosity, how many hours would you estimate it would take to setup a PKI infrastructure and ICBM for SCCM 2012 R2? My boss has asked me to implement and I have no idea what to guestimate for hours. Looking for someone who has experience with implementing both PKI and ICBM that might be able to give me a rough idea of how many hours this would take. From what I've read ICBM is complex to setup, but that was back in CM07. Not sure how much has changed with CM12. Thanks, Brian
RE: [mssms] SCCM 2012, PKI and ICBM
Correct me if I am wrong, but I don't think we can run the Intune client and ConfigMgr client side by side on one system. Michael Dzikowski Senior Systems Engineer | Ally Technical Infrastructure - Windows Hosting [cid:image002.gif@01CDF887.776259A0] From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Friday, January 24, 2014 10:08 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM What about Windows Intune fitting into the discussion as a possible solution? This would get us what we need (Patch Deployment, Compliance Management, Software Deployment). This gives us the same ability to manage internet clients all from a single pane in CM12. From: mcdonald...@hotmail.commailto:mcdonald...@hotmail.com To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM Date: Fri, 24 Jan 2014 09:04:55 -0600 Discussing this with my counterpart now. No, we do not have a PKI infrastructure. I came across this recently. There may be other sources out there but this does seem fairly straight forward. http://blogs.msdn.com/b/scstr/archive/2012/05/31/step_2d00_by_2d00_step_2d00_example_2d00_deployment_2d00_of_2d00_the_2d00_pki_2d00_certificates_2d00_for_2d00_configuration_2d00_manager_2d00_2012_2d00_windows_2d00_server_2d00_2008.aspx I'm entirely new to PKI, so any direction would be nice. Thanks, Brian From: eric.morri...@hotmail.commailto:eric.morri...@hotmail.com To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM Date: Wed, 22 Jan 2014 09:29:09 -0600 Setting up IBCM in 2012 is a breeze compared to the 2007 days. I've configured IBCM in both versions and as long as you have basic PKI understanding, you shouldn't have too many roadblocks. In the environment you are going to use to set it up, do you already have PKI setup with machine certificates deployed, specifically workstations to be managed over the internet? You'll also need to either stand up a new site system server in your DMZ, or have the ports reverse proxy to your primary site server. If you're going to do Software Distribution, Software Updates, and App Catalog, then you'll need to make sure those roles are setup as HTTPS and the appropriate web server cert in IIS and make sure the roles allow intranet and internet. After that it's just a matter of making sure the clients have the public fqdn configured for IBCM and that the firewall ports are open. Now, if DA is the option like so many suggested, definitely go that route... :) Thanks, Eric Morrison From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, January 21, 2014 2:52 PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com; mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] SCCM 2012, PKI and ICBM Hey everyone, Just out of curiosity, how many hours would you estimate it would take to setup a PKI infrastructure and ICBM for SCCM 2012 R2? My boss has asked me to implement and I have no idea what to guestimate for hours. Looking for someone who has experience with implementing both PKI and ICBM that might be able to give me a rough idea of how many hours this would take. From what I've read ICBM is complex to setup, but that was back in CM07. Not sure how much has changed with CM12. Thanks, Brian inline: image001.png
[mssms] Adobe Updates Failures
Do others see high failure rates when deploying Adobe updates via SCUP/ConfigMgr? I average ~50% failures. John Marcum 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.
[mssms] RE: Adobe Updates Failures
I broke my Adobe and Java out of SCUP and use a ConfigMgr task sequence to patch it. I can share it with you if you like. Thanks, Chris Brucker From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Friday, January 24, 2014 10:11 AM To: SMS List (mssms@lists.myITforum.com) Subject: [mssms] Adobe Updates Failures Do others see high failure rates when deploying Adobe updates via SCUP/ConfigMgr? I average ~50% failures. John Marcum 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. ** The information contained in this message from First Financial Bancorp or its affiliates and any attachments are confidential. It is not intended for transmission to, or receipt by, anyone other than the addressee(s), or a person authorized to deliver it to the named addressee(s). If you have received this message in error, you are prohibited from copying, distributing or using the information. Please contact the sender immediately by return email and delete the original message.
[mssms] RE: Adobe Updates Failures
Reader? Or Std/pro? 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.comhttp://www.us.sogeti.com/ From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Friday, January 24, 2014 10:11 AM To: SMS List (mssms@lists.myITforum.com) Subject: [mssms] Adobe Updates Failures Do others see high failure rates when deploying Adobe updates via SCUP/ConfigMgr? I average ~50% failures. John Marcum 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. inline: image001.jpg
RE: [mssms] Re: [MDT-OSD] SCCM Imaging opening at General Mills.
Most HR policies regarding salary ranges. 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.comhttp://www.us.sogeti.com/ From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Dzikowski, Michael Sent: Friday, January 24, 2014 10:07 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] Re: [MDT-OSD] SCCM Imaging opening at General Mills. I don't think the position itself requires a degree or should require a degree. However, some companies have HR requirements that say certain types of positions within a company, require degrees. Michael Dzikowski Senior Systems Engineer | Ally Technical Infrastructure - Windows Hosting [cid:image002.gif@01CDF887.776259A0] From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jimmy Martin Sent: Thursday, January 23, 2014 4:19 PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: RE: [mssms] Re: [MDT-OSD] SCCM Imaging opening at General Mills. I grew into my position too... degree in respiratory therapy :) but always a geek at heart From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Rickym61 Sent: Thursday, January 23, 2014 3:13 PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] Re: [MDT-OSD] SCCM Imaging opening at General Mills. Just curious why do most SCCM jobs require some form of degree? Surely there are quite a few SCCM/CM admins (senior/junior) ones out there without a degree, doesn't experience in the role count more than a degree? On Thursday, 23 January 2014, Richard Zuraff richard.zur...@genmills.commailto:richard.zur...@genmills.com wrote: We have an opening for a SCCM Imaging expert in Minneapolis, MN here at General Mills, Inc. If you know anyone that is qualified and looking, please pass along. http://jobs.generalmills.com/minneapolis/experienced/jobid4771117-image-management-technician-sccm-jobs Thanks This message and any files transmitted with it may contain legally privileged, confidential, or proprietary information. If you are not the intended recipient of this message, you are not permitted to use, copy, or forward it, in whole or in part without the express consent of the sender. Please notify the sender of the error by reply email, disregard the foregoing messages, and delete it immediately. P Please consider the environment before printing this email... inline: image002.jpginline: image003.png
RE: [mssms] SCCM 2012, PKI and ICBM
That's correct. Also, Windows systems managed by Intune are not manageable from ConfigMgr using the Intune connector - the Intune connector is explicitly only for mobile devices (not that Win 8.1 can actually act like a mobile device but you lose any ability to perform software updates or manage SCEP when you manage it this way). J From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Dzikowski, Michael Sent: Friday, January 24, 2014 9:10 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM Correct me if I am wrong, but I don't think we can run the Intune client and ConfigMgr client side by side on one system. Michael Dzikowski Senior Systems Engineer | Ally Technical Infrastructure - Windows Hosting [cid:image002.gif@01CDF887.776259A0] From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Friday, January 24, 2014 10:08 AM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM What about Windows Intune fitting into the discussion as a possible solution? This would get us what we need (Patch Deployment, Compliance Management, Software Deployment). This gives us the same ability to manage internet clients all from a single pane in CM12. From: mcdonald...@hotmail.commailto:mcdonald...@hotmail.com To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM Date: Fri, 24 Jan 2014 09:04:55 -0600 Discussing this with my counterpart now. No, we do not have a PKI infrastructure. I came across this recently. There may be other sources out there but this does seem fairly straight forward. http://blogs.msdn.com/b/scstr/archive/2012/05/31/step_2d00_by_2d00_step_2d00_example_2d00_deployment_2d00_of_2d00_the_2d00_pki_2d00_certificates_2d00_for_2d00_configuration_2d00_manager_2d00_2012_2d00_windows_2d00_server_2d00_2008.aspx I'm entirely new to PKI, so any direction would be nice. Thanks, Brian From: eric.morri...@hotmail.commailto:eric.morri...@hotmail.com To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012, PKI and ICBM Date: Wed, 22 Jan 2014 09:29:09 -0600 Setting up IBCM in 2012 is a breeze compared to the 2007 days. I've configured IBCM in both versions and as long as you have basic PKI understanding, you shouldn't have too many roadblocks. In the environment you are going to use to set it up, do you already have PKI setup with machine certificates deployed, specifically workstations to be managed over the internet? You'll also need to either stand up a new site system server in your DMZ, or have the ports reverse proxy to your primary site server. If you're going to do Software Distribution, Software Updates, and App Catalog, then you'll need to make sure those roles are setup as HTTPS and the appropriate web server cert in IIS and make sure the roles allow intranet and internet. After that it's just a matter of making sure the clients have the public fqdn configured for IBCM and that the firewall ports are open. Now, if DA is the option like so many suggested, definitely go that route... :) Thanks, Eric Morrison From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, January 21, 2014 2:52 PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com; mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] SCCM 2012, PKI and ICBM Hey everyone, Just out of curiosity, how many hours would you estimate it would take to setup a PKI infrastructure and ICBM for SCCM 2012 R2? My boss has asked me to implement and I have no idea what to guestimate for hours. Looking for someone who has experience with implementing both PKI and ICBM that might be able to give me a rough idea of how many hours this would take. From what I've read ICBM is complex to setup, but that was back in CM07. Not sure how much has changed with CM12. Thanks, Brian inline: image001.png
[mssms] RE: ConfigMgr and Unix Patching?
You better blog the crap out of that if you do it. I see most folks using something like Puppet for *nix patching. 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.comhttp://www.us.sogeti.com/ From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Dzikowski, Michael Sent: Friday, January 24, 2014 9:50 AM To: mssms@lists.myitforum.com Subject: [mssms] ConfigMgr and Unix Patching? Anyone actually patching Unix / Linux systems in production with ConfigMgr? UNIX/Linux Client: The following UNIX and Linux versions are supported in this release. * AIX Version 7.1, 6.1, 5.3 * Solaris Version 11, 10, 9 * HP-UX Version 11iv2 , 11iv3 * RHEL Version 6 , 5, 4 * SLES Version 11, 10, 9 * CentOS Version 6, 5 * Debian Version 6, 5 * Ubuntu Version 12.4 LTS, 10.4 LTS * Oracle Linux 6, 5 The following scenarios are supported by the UNIX and Linux clients: * Hardware Inventory - Hardware inventory can be viewed through Resource Explorer and can be used to create collections of UNIX and Linux computers. * Software Inventory - Through hardware inventory the list of natively installed software can be gathered from the UNIX and Linux computers - similar to add/remove programs for Windows systems. * Software Distribution - Deploy new software, update existing software and apply OS patches to collections of UNIX/Linux computers (using a package and program). Run arbitrary maintenance scripts on a collection of UNIX/Linux servers. * Secure and Authenticated Communications * Consolidated Reports Michael Dzikowski Senior Systems Engineer | Ally Technical Infrastructure - Windows Hosting [cid:image002.gif@01CDF887.776259A0] inline: image002.jpginline: image003.png
[mssms] RE: Adobe Updates Failures
I would be interested in seeing what you did. Thanks, Ken ... From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brucker, Chris Sent: Friday, January 24, 2014 7:34 AM To: 'mssms@lists.myitforum.com' Subject: [mssms] RE: Adobe Updates Failures I broke my Adobe and Java out of SCUP and use a ConfigMgr task sequence to patch it. I can share it with you if you like. Thanks, Chris Brucker From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Friday, January 24, 2014 10:11 AM To: SMS List (mssms@lists.myITforum.commailto:mssms@lists.myITforum.com) Subject: [mssms] Adobe Updates Failures Do others see high failure rates when deploying Adobe updates via SCUP/ConfigMgr? I average ~50% failures. John Marcum 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. The information contained in this message from First Financial Bancorp or its affiliates and any attachments are confidential. It is not intended for transmission to, or receipt by, anyone other than the addressee(s), or a person authorized to deliver it to the named addressee(s). If you have received this message in error, you are prohibited from copying, distributing or using the information. Please contact the sender immediately by return email and delete the original message.
[mssms] RE: Adobe Updates Failures
that would be great John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brucker, Chris Sent: Friday, January 24, 2014 9:34 AM To: 'mssms@lists.myitforum.com' Subject: [mssms] RE: Adobe Updates Failures I broke my Adobe and Java out of SCUP and use a ConfigMgr task sequence to patch it. I can share it with you if you like. Thanks, Chris Brucker From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Friday, January 24, 2014 10:11 AM To: SMS List (mssms@lists.myITforum.commailto:mssms@lists.myITforum.com) Subject: [mssms] Adobe Updates Failures Do others see high failure rates when deploying Adobe updates via SCUP/ConfigMgr? I average ~50% failures. John Marcum 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. The information contained in this message from First Financial Bancorp or its affiliates and any attachments are confidential. It is not intended for transmission to, or receipt by, anyone other than the addressee(s), or a person authorized to deliver it to the named addressee(s). If you have received this message in error, you are prohibited from copying, distributing or using the information. Please contact the sender immediately by return email and delete the original message. Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
[mssms] RE: Adobe Updates Failures
I'm patching all of the above plus flash. For some reason I am missing the report Updates - C Deployment States/States 7 - Error status messages for a computer (secondary)' cannot be found. which I think is the one I need to figure out exactly which update is failing. I've tried and tried to reset the reports to the default install but it never works. I guess I need to call CSS and get some help with that. If someone could send me the rdl for the missing report I'd really appreciate it. John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of christopher.catl...@us.sogeti.com Sent: Friday, January 24, 2014 9:40 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: Adobe Updates Failures Reader? Or Std/pro? 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.comhttp://www.us.sogeti.com/ From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Friday, January 24, 2014 10:11 AM To: SMS List (mssms@lists.myITforum.commailto:mssms@lists.myITforum.com) Subject: [mssms] Adobe Updates Failures Do others see high failure rates when deploying Adobe updates via SCUP/ConfigMgr? I average ~50% failures. John Marcum 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. Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. inline: image001.jpg
[mssms] RE: Adobe Updates Failures
Odds are PSS will need you to run mofcomp to recreate the reports. I had to do that when I went from 2012 RTM to the TAP version of SP1, I had zero reports after the upgrade (that was a 'fun' moment.) 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.comhttp://www.us.sogeti.com/ From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Friday, January 24, 2014 11:28 AM To: 'mssms@lists.myitforum.com' Subject: [mssms] RE: Adobe Updates Failures I'm patching all of the above plus flash. For some reason I am missing the report Updates - C Deployment States/States 7 - Error status messages for a computer (secondary)' cannot be found. which I think is the one I need to figure out exactly which update is failing. I've tried and tried to reset the reports to the default install but it never works. I guess I need to call CSS and get some help with that. If someone could send me the rdl for the missing report I'd really appreciate it. John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of christopher.catl...@us.sogeti.commailto:christopher.catl...@us.sogeti.com Sent: Friday, January 24, 2014 9:40 AM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] RE: Adobe Updates Failures Reader? Or Std/pro? 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.comhttp://www.us.sogeti.com/ From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Friday, January 24, 2014 10:11 AM To: SMS List (mssms@lists.myITforum.commailto:mssms@lists.myITforum.com) Subject: [mssms] Adobe Updates Failures Do others see high failure rates when deploying Adobe updates via SCUP/ConfigMgr? I average ~50% failures. John Marcum 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. Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. inline: image001.jpg
[mssms] Create custom report in SCCM 2012
Hi all, Can you guide me, how to create custom(SQL) report in SCCM 2012 server? Regards Rajan K
RE: [mssms] Create custom report in SCCM 2012
It's good practice to create reports based on SQL views only. The challenge is
to get a good overview of all the views and how they are related.
CM07 has a pretty useful tool that can assist you. Albeit, the views in CM12
are not 100% identical, it's still a pretty good way to get started.
Download the and install the CreatingCustomReportsByUsingSQLViews.msi file
Once you have this installed open C:\Program Files (x86)\Configuration Manager
2007 Documentation\Creating Custom Reports by Using Configuration Manager 2007
SQL View - note you have a Visio document and Excel spreadsheet.
If you open the Visio document and select the Discovery tab, notice all the
views. Next, look at Hardware Inventory.
Another thing you can do is open SQL Management Studio connect to the CM_XXX
database and create a new query like this:
select distinct table_name,COLUMN_Name from
Information_Schema.columns
where table_name LIKE ('v_') Order by table_name
Take a look at all the views returned.
This will give you an idea of the possibilities. If you want to create custom
reports do some digging on using...SQL Server Data Tools - Business
Intelligence Settings and start Visual Studio.
I'm sure there's some resources available some place to get you going on
creating custom reports from there.
Rich C.
From: rajan@hotmail.com
To: mssms@lists.myitforum.com
Subject: [mssms] Create custom report in SCCM 2012
Date: Fri, 24 Jan 2014 23:51:45 +0530
Hi all,
Can you guide me, how to create custom(SQL) report in SCCM 2012
server?
Regards
Rajan K
CONFIDENTIALITY NOTICE: This electronic mail transmission (including any
accompanying attachments) is intended solely for its authorized recipient(s),
and may contain confidential and/or legally privileged information. If you are
not an intended recipient, or responsible for delivering some or all of this
transmission to an intended recipient, be aware that any review, copying,
printing, distribution, use or disclosure of the contents of this message is
strictly prohibited. If you have received this electronic mail message in
error, please delete it from your system without copying it, and contact sender
immediately by Reply e-mail, or by calling 913-307-2300, so that our address
records can be corrected.
Although this e-mail and any attachments are believed to be free of any virus
or other defect that might negatively affect any computer system into which it
is received and opened, it is the responsibility of the recipient to ensure
that it is virus free and no responsibility is accepted by the sender for any
loss or damage arising in any way in the event that such a virus or defect
exists.
RE: [mssms] Create custom report in SCCM 2012
Nice! Good to know.
-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Daniel Ratliff
Sent: Friday, January 24, 2014 1:58 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] Create custom report in SCCM 2012
They just released the 2012 views on TechNet.
http://technet.microsoft.com/en-us/library/dn581954.aspx
Daniel Ratliff
-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Rich Coulter
Sent: Friday, January 24, 2014 2:35 PM
To: mssms@lists.myITforum.com
Subject: RE: [mssms] Create custom report in SCCM 2012
It's good practice to create reports based on SQL views only. The challenge is
to get a good overview of all the views and how they are related.
CM07 has a pretty useful tool that can assist you. Albeit, the views in CM12
are not 100% identical, it's still a pretty good way to get started.
Download the and install the CreatingCustomReportsByUsingSQLViews.msi file
Once you have this installed open C:\Program Files (x86)\Configuration Manager
2007 Documentation\Creating Custom Reports by Using Configuration Manager 2007
SQL View - note you have a Visio document and Excel spreadsheet.
If you open the Visio document and select the Discovery tab, notice all the
views. Next, look at Hardware Inventory.
Another thing you can do is open SQL Management Studio connect to the CM_XXX
database and create a new query like this:
select distinct table_name,COLUMN_Name from Information_Schema.columns where
table_name LIKE ('v_') Order by table_name
Take a look at all the views returned.
This will give you an idea of the possibilities. If you want to create custom
reports do some digging on using...SQL Server Data Tools - Business
Intelligence Settings and start Visual Studio.
I'm sure there's some resources available some place to get you going on
creating custom reports from there.
Rich C.
From: rajan@hotmail.com
To: mssms@lists.myitforum.com
Subject: [mssms] Create custom report in SCCM 2012
Date: Fri, 24 Jan 2014 23:51:45 +0530
Hi all,
Can you guide me, how to create custom(SQL) report in SCCM 2012
server?
Regards
Rajan K
CONFIDENTIALITY NOTICE: This electronic mail transmission (including any
accompanying attachments) is intended solely for its authorized recipient(s),
and may contain confidential and/or legally privileged information. If you are
not an intended recipient, or responsible for delivering some or all of this
transmission to an intended recipient, be aware that any review, copying,
printing, distribution, use or disclosure of the contents of this message is
strictly prohibited. If you have received this electronic mail message in
error, please delete it from your system without copying it, and contact sender
immediately by Reply e-mail, or by calling 913-307-2300, so that our address
records can be corrected.
Although this e-mail and any attachments are believed to be free of any virus
or other defect that might negatively affect any computer system into which it
is received and opened, it is the responsibility of the recipient to ensure
that it is virus free and no responsibility is accepted by the sender for any
loss or damage arising in any way in the event that such a virus or defect
exists.
The information transmitted is intended only for the person or entity to which
it is addressed and may contain CONFIDENTIAL material. If you receive this
material/information in error, please contact the sender and delete or destroy
the material/information.
CONFIDENTIALITY NOTICE: This electronic mail transmission (including any
accompanying attachments) is intended solely for its authorized recipient(s),
and may contain confidential and/or legally privileged information. If you are
not an intended recipient, or responsible for delivering some or all of this
transmission to an intended recipient, be aware that any review, copying,
printing, distribution, use or disclosure of the contents of this message is
strictly prohibited. If you have received this electronic mail message in
error, please delete it from your system without copying it, and contact sender
immediately by Reply e-mail, or by calling 913-307-2300, so that our address
records can be corrected.
Although this e-mail and any attachments are believed to be free of any virus
or other defect that might negatively affect any computer system into which it
is received and opened, it is the responsibility of the recipient to ensure
that it is virus free and no responsibility is accepted by the sender for any
loss or damage arising in any way in the event that such a virus or defect
exists.
RE: [mssms] Create custom report in SCCM 2012
They just released the 2012 views on TechNet.
http://technet.microsoft.com/en-us/library/dn581954.aspx
Daniel Ratliff
-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Rich Coulter
Sent: Friday, January 24, 2014 2:35 PM
To: mssms@lists.myITforum.com
Subject: RE: [mssms] Create custom report in SCCM 2012
It's good practice to create reports based on SQL views only. The challenge is
to get a good overview of all the views and how they are related.
CM07 has a pretty useful tool that can assist you. Albeit, the views in CM12
are not 100% identical, it's still a pretty good way to get started.
Download the and install the CreatingCustomReportsByUsingSQLViews.msi file
Once you have this installed open C:\Program Files (x86)\Configuration Manager
2007 Documentation\Creating Custom Reports by Using Configuration Manager 2007
SQL View - note you have a Visio document and Excel spreadsheet.
If you open the Visio document and select the Discovery tab, notice all the
views. Next, look at Hardware Inventory.
Another thing you can do is open SQL Management Studio connect to the CM_XXX
database and create a new query like this:
select distinct table_name,COLUMN_Name from Information_Schema.columns where
table_name LIKE ('v_') Order by table_name
Take a look at all the views returned.
This will give you an idea of the possibilities. If you want to create custom
reports do some digging on using...SQL Server Data Tools - Business
Intelligence Settings and start Visual Studio.
I'm sure there's some resources available some place to get you going on
creating custom reports from there.
Rich C.
From: rajan@hotmail.com
To: mssms@lists.myitforum.com
Subject: [mssms] Create custom report in SCCM 2012
Date: Fri, 24 Jan 2014 23:51:45 +0530
Hi all,
Can you guide me, how to create custom(SQL) report in SCCM 2012
server?
Regards
Rajan K
CONFIDENTIALITY NOTICE: This electronic mail transmission (including any
accompanying attachments) is intended solely for its authorized recipient(s),
and may contain confidential and/or legally privileged information. If you are
not an intended recipient, or responsible for delivering some or all of this
transmission to an intended recipient, be aware that any review, copying,
printing, distribution, use or disclosure of the contents of this message is
strictly prohibited. If you have received this electronic mail message in
error, please delete it from your system without copying it, and contact sender
immediately by Reply e-mail, or by calling 913-307-2300, so that our address
records can be corrected.
Although this e-mail and any attachments are believed to be free of any virus
or other defect that might negatively affect any computer system into which it
is received and opened, it is the responsibility of the recipient to ensure
that it is virus free and no responsibility is accepted by the sender for any
loss or damage arising in any way in the event that such a virus or defect
exists.
The information transmitted is intended only for the person or entity to which
it is addressed
and may contain CONFIDENTIAL material. If you receive this
material/information in error,
please contact the sender and delete or destroy the material/information.
Re: [mssms] Create custom report in SCCM 2012
TechNet has documentation on creating reports using the views in the configmgr DB: http://technet.microsoft.com/en-us/library/dn581954.aspx Jeff On Fri, Jan 24, 2014 at 12:53 PM, christopher.catl...@us.sogeti.com wrote: What do you want to report on? They are just SSRS reports, nothing fancy. You just pull the data from the ConfgMgr sql views (I try to use these over direct table access) *Christopher Catlett* Consultant | Detroit *[image: 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.myitforum.com [mailto: listsad...@lists.myitforum.com] *On Behalf Of *Rajan Hotmail *Sent:* Friday, January 24, 2014 1:22 PM *To:* mssms@lists.myitforum.com *Subject:* [mssms] Create custom report in SCCM 2012 Hi all, Can you guide me, how to create custom(SQL) report in SCCM 2012 server? Regards Rajan K image001.jpg
[mssms] RE: MBAM with ConfigMgr
Yes, you point the URL to the MBAM server instead of the CM server. I'm not sure if I ever blogged it. Basically just install it like this: http://myitforum.com/myitforumwp/2013/06/10/how-to-install-mbam-2-0-with-configmgr-integration/ Then run the install on the MBAM server as well and point the GPO's to the MBAM server for reporting. (as best as I can remember, it's been awhile) John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Hedges, Dustin Sent: Friday, January 24, 2014 1:31 PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] RE: MBAM with ConfigMgr Been using 1.0 for a year now. About to do the jump to 2.0 SP1 (with SCCM integration). Been rock solid for me. John, where is your blog on your hybrid install? That's what I plan on doing. Do you just keep the ComplianceStatus URL in the GPO As-Is? Dustin Hedges Sr. Systems Engineer GETOps - Global Client Engineering [cid:image002.jpg@01CED6D7.26B40DD0] From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Thursday, January 23, 2014 7:31 PM To: 'mssms@lists.myitforum.com' Subject: [mssms] RE: MBAM with ConfigMgr I've version 1 and version 2. Blogged some about deploying version 2. Main thing about version 2 with ConfigMgr integration is that it doesn't keep compliance data any longer than computer inventory. For the healthcare firm I was with that was not acceptable so I did a hybrid install. Putting the compliance data in MBAM keeps it forever. John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Beardsley, James Sent: Thursday, January 23, 2014 1:54 PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] RE: MBAM with ConfigMgr Are you talking about the MBAM/SCCM integration? Or just the MBAM client? We're in the process of testing the MBAM client deployment in our IT dept. So far, no issues. We just pushed out the .msi and then imported some registry keys associated with it. If you're talking about the integration piece, we aren't there yet. From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Timothy Ransom Sent: Thursday, January 23, 2014 2:31 PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] MBAM with ConfigMgr Hi, Has anyone deployed MBAM with ConfigMgr ? I will be deploying next week with a partner but haven't seen any reviews yet. Thanks, Tim ** GDOL CONFIDENTIALITY NOTICE: This transmission may contain confidential information protected by state or federal law. The information is intended only for use consistent with the state business discussed in this transmission. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action based on the contents is strictly prohibited. If you have received this transmission in error, please delete this email and notify the sender immediately. Your cooperation is appreciated. ** IRS Compliance: Any tax advice contained in this communication (including any attachments) is not intended or written to be used, and cannot be used, for the purpose of (i) avoiding penalties imposed under the Internal Revenue Code or applicable state or local tax law or (ii) promoting, marketing, or recommending to another party any transaction or matter addressed herein. Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation. 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
[mssms] R2 client upgrade question
I am curious what everyone is doing with R2 client upgrades. Outside of OSD and before addressing the R2 hotfix KB2905002, I am trying to figure the best way to upgrade clients from the SP1 CU3 version (5.00.7804.1400) to the initial R2 version (5.00.7958.1000). Some observations... 1. From previous email threads, I've notice recommendations to use Automatic Client Upgrade. However, when I enable this feature...there is wording in the UI that saysClients in slow or unreliable boundaries will not be upgraded automatically. 2. When I installed R2 on my lab primary site, there wasn't an option to include a client installer package like how we saw with SP1 or CU3 site installs (unless I missed that). So, I am trying to confirm if my observations are correct. And if so, what is everyone doing with client upgrades in slow boundaries? Do we create a package for them? Thanks, Elias
RE: [mssms] R2 client upgrade question
Elias, Yes, I just recently used a ConfigMgr client package to upgrade a customer from Service Pack 1 to R2. The upgrade process went flawlessly. I used a wrapper batch file that would: 1. Kill ccmsetup.exe (if running) using taskkill.exe 2. Launch ccmsetup.exe with the /NoService parameter 3. Install Microsoft KB2905002 using msiexec.exe /update There was some issue I ran into while trying to install KB2905002 using the PATCH property, but I cannot recall what it was. That's why I just used msiexec.exe Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Elias Leal Sent: Friday, January 24, 2014 3:38 PM To: mssms@lists.myitforum.com Subject: [mssms] R2 client upgrade question I am curious what everyone is doing with R2 client upgrades. Outside of OSD and before addressing the R2 hotfix KB2905002, I am trying to figure the best way to upgrade clients from the SP1 CU3 version (5.00.7804.1400) to the initial R2 version (5.00.7958.1000). Some observations... 1. From previous email threads, I've notice recommendations to use Automatic Client Upgrade. However, when I enable this feature...there is wording in the UI that saysClients in slow or unreliable boundaries will not be upgraded automatically. 2. When I installed R2 on my lab primary site, there wasn't an option to include a client installer package like how we saw with SP1 or CU3 site installs (unless I missed that). So, I am trying to confirm if my observations are correct. And if so, what is everyone doing with client upgrades in slow boundaries? Do we create a package for them? Thanks, Elias
RE: [mssms] R2 client upgrade question
Trevor, Curious as to why you killed CCMSETUP first? As a best practice just in case it's running still from a previous attempt? Thanks. Ivan Lindenfeld From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sullivan Sent: Friday, January 24, 2014 4:41 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] R2 client upgrade question Elias, Yes, I just recently used a ConfigMgr client package to upgrade a customer from Service Pack 1 to R2. The upgrade process went flawlessly. I used a wrapper batch file that would: 1. Kill ccmsetup.exe (if running) using taskkill.exe 2. Launch ccmsetup.exe with the /NoService parameter 3. Install Microsoft KB2905002 using msiexec.exe /update There was some issue I ran into while trying to install KB2905002 using the PATCH property, but I cannot recall what it was. That's why I just used msiexec.exe Cheers, Trevor Sullivan From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Elias Leal Sent: Friday, January 24, 2014 3:38 PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Subject: [mssms] R2 client upgrade question I am curious what everyone is doing with R2 client upgrades. Outside of OSD and before addressing the R2 hotfix KB2905002, I am trying to figure the best way to upgrade clients from the SP1 CU3 version (5.00.7804.1400) to the initial R2 version (5.00.7958.1000). Some observations... 1. From previous email threads, I've notice recommendations to use Automatic Client Upgrade. However, when I enable this feature...there is wording in the UI that saysClients in slow or unreliable boundaries will not be upgraded automatically. 2. When I installed R2 on my lab primary site, there wasn't an option to include a client installer package like how we saw with SP1 or CU3 site installs (unless I missed that). So, I am trying to confirm if my observations are correct. And if so, what is everyone doing with client upgrades in slow boundaries? Do we create a package for them? Thanks, Elias
Re: [mssms] R2 client upgrade question
Thanks, Trevor. That make sense. It just seems with R2, performing the client upgrade is not as intuitive as it has been with SP1 or CU3 where the site installer asked you if you wanted to create a package for your client and console upgrades. And, I can't see using the Automatic Client Upgrade feature as being a comprehensive solution. If I recall, I thought I read in past Technet documentation that the Automatic Client Upgrade was not recommended to fully upgrade your entire client environment, but rather only after you have performed some mass client package push. In other words, for those the small percentage remaining on the older client version. Elias On Fri, Jan 24, 2014 at 3:41 PM, Trevor Sullivan tsul...@gmail.com wrote: Elias, Yes, I just recently used a ConfigMgr client package to upgrade a customer from Service Pack 1 to R2. The upgrade process went flawlessly. I used a wrapper batch file that would: 1. Kill *ccmsetup.exe* (if running) using *taskkill.exe* 2. Launch *ccmsetup.exe* with the */NoService* parameter 3. Install Microsoft KB2905002 using *msiexec.exe /update* There was some issue I ran into while trying to install KB2905002 using the PATCH property, but I cannot recall what it was. That's why I just used msiexec.exe Cheers, Trevor Sullivan *From:* listsad...@lists.myitforum.com [mailto: listsad...@lists.myitforum.com] *On Behalf Of *Elias Leal *Sent:* Friday, January 24, 2014 3:38 PM *To:* mssms@lists.myitforum.com *Subject:* [mssms] R2 client upgrade question I am curious what everyone is doing with R2 client upgrades. Outside of OSD and before addressing the R2 hotfix KB2905002, I am trying to figure the best way to upgrade clients from the SP1 CU3 version (5.00.7804.1400) to the initial R2 version (5.00.7958.1000). Some observations... 1. From previous email threads, I've notice recommendations to use Automatic Client Upgrade. However, when I enable this feature...there is wording in the UI that saysClients in slow or unreliable boundaries will not be upgraded automatically. 2. When I installed R2 on my lab primary site, there wasn't an option to include a client installer package like how we saw with SP1 or CU3 site installs (unless I missed that). So, I am trying to confirm if my observations are correct. And if so, what is everyone doing with client upgrades in slow boundaries? Do we create a package for them? Thanks, Elias
RE: [mssms] R2 client upgrade question
Ivan, Yes, sir. It's just a precaution, if nothing else. During my development / testing period, I would regularly come across cases where I invoked ccmsetup.exe asynchronously, and instead meant to launch it synchronously. In those cases, I'd have to kill the async ccmsetup.exe (which was running as a service, and probably just sleeping, waiting for content), to allow the synchronous invocation to run successfully. As long as there aren't any client installations or uninstallations running, killing ccmsetup.exe should be relatively safe. Even then, ccmsetup.exe simply calls out to other processes (eg. msiexec.exe, prerequisite files, etc.), so it's not like you're interrupting any installation itself, just the installation wrapper. Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Lindenfeld, Ivan Sent: Friday, January 24, 2014 3:46 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] R2 client upgrade question Trevor, Curious as to why you killed CCMSETUP first? As a best practice just in case it's running still from a previous attempt? Thanks. Ivan Lindenfeld From: listsad...@lists.myitforum.com mailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sullivan Sent: Friday, January 24, 2014 4:41 PM To: mssms@lists.myitforum.com mailto:mssms@lists.myitforum.com Subject: RE: [mssms] R2 client upgrade question Elias, Yes, I just recently used a ConfigMgr client package to upgrade a customer from Service Pack 1 to R2. The upgrade process went flawlessly. I used a wrapper batch file that would: 1. Kill ccmsetup.exe (if running) using taskkill.exe 2. Launch ccmsetup.exe with the /NoService parameter 3. Install Microsoft KB2905002 using msiexec.exe /update There was some issue I ran into while trying to install KB2905002 using the PATCH property, but I cannot recall what it was. That's why I just used msiexec.exe Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com mailto:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Elias Leal Sent: Friday, January 24, 2014 3:38 PM To: mssms@lists.myitforum.com mailto:mssms@lists.myitforum.com Subject: [mssms] R2 client upgrade question I am curious what everyone is doing with R2 client upgrades. Outside of OSD and before addressing the R2 hotfix KB2905002, I am trying to figure the best way to upgrade clients from the SP1 CU3 version (5.00.7804.1400) to the initial R2 version (5.00.7958.1000). Some observations... 1. From previous email threads, I've notice recommendations to use Automatic Client Upgrade. However, when I enable this feature...there is wording in the UI that saysClients in slow or unreliable boundaries will not be upgraded automatically. 2. When I installed R2 on my lab primary site, there wasn't an option to include a client installer package like how we saw with SP1 or CU3 site installs (unless I missed that). So, I am trying to confirm if my observations are correct. And if so, what is everyone doing with client upgrades in slow boundaries? Do we create a package for them? Thanks, Elias
