RE: [mssms] SQL SUM Rows - Status of a Specific Advertisment

2013-09-13 Thread Jitendra Ramesh Kalyankar
Hi Stefanie – Try using UNPIVOT command in the last query. You can get few examples around UNPIVOT command if you Bing it. Let me know if you need help in writing it. Thanks, JitenRK From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of

[mssms] RE: Software updates reboot query

2013-09-13 Thread Andrew . Bohan
Return Receipt Your [mssms] RE: Software updates reboot query document:

RE: [mssms] RE: Software updates reboot query

2013-09-13 Thread Andrew . Bohan
Return Receipt Your RE: [mssms] RE: Software updates reboot query document:

[mssms] Validate content not working for legacy packages?

2013-09-13 Thread Ryan
So we were having problems with imaging, and I validated the content to be sure it was on all DPs. The Win7 image came back 100% successful. I then finally got logs from the guy in California (Have only been asking for a week now) and I found that it wasn't finding the package on the server. So,

[mssms] Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Spinelli, Robert J
I know this has been discussed before, but can't seem to fine the thread. If you want to create a computer object for OSD on your CAS it takes a few minutes before it actually shows up in the collection. I understand it's because the evaluation actually occurs on the primary and then comes

RE: [mssms] Validate content not working for legacy packages?

2013-09-13 Thread Dzikowski, Michael
What happens if you update your DP? Or resend the package? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Ryan Sent: Friday, September 13, 2013 9:41 AM To: mssms@lists.myitforum.com Subject: [mssms] Validate content not working for legacy packages?

Re: RE: [mssms] SQL SUM Rows - Status of a Specific Advertisment

2013-09-13 Thread stefanieburton
Hi Jitendra,Thanks for responding. I am reading through the net trying to understand how to use pivot and unpivot. But if you have experience with how to write the query, I will take any help I can get.ThanksStefanieOn 09/13/13, Jitendra Ramesh Kalyankarjite...@microsoft.com wrote:Hi Stefanie –Try

RE: [mssms] Validate content not working for legacy packages?

2013-09-13 Thread Mike Gouldthorp
I'm seeing the same issue as well. Despite scheduling a weekly DP validation task I will find legacy packages missing from the SMSPKG share. Unfortunately I've been unable to find a solution. I essentially have to wait for the OS\package deployment to fail then redistribute the content to the

[mssms] MDT Gather / cleartext password

2013-09-13 Thread Stuart Watret
So was it always the case that the ztigather task stored the domain join credentials and displayed them in the debug mode? I was using it to check the reported model name and just managed to spot my account password on the screen. Stuart Watret Offshore - IT Ltd

Re: [mssms] MDT Gather / cleartext password

2013-09-13 Thread CESAR.ABREG0 .
Yes. There are a couple of blogs in how to encrypt it I think. Also, if you output TS vars, you can see CM's NAA as well, Johan has like a 4 line vbs that outputs them all to a txt. On Sep 13, 2013 8:43 AM, Stuart Watret stu...@offshore-it.co.uk wrote: So was it always the case that the

RE: RE: [mssms] SQL SUM Rows - Status of a Specific Advertisment

2013-09-13 Thread Jitendra Kalyankar
Sure will write something that would help but not before Monday. Hth Jitendra Sent from my Windows Phone -- From: stefaniebur...@verizon.net Sent: 13-09-2013 20:28 To: mssms@lists.myitforum.com Subject: Re: RE: [mssms] SQL SUM Rows - Status of a Specific

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Marcum, John
use unknown computers. John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Spinelli, Robert J Sent: Friday, September 13,

[mssms] Blue Screen data.

2013-09-13 Thread Richard Zuraff
Is anyone collecting Blue Screen crashes using SCCM 2007 or SCCM 2012 on Windows 7 x64? We collect it on XP, but it doesn't seem to work on Windows 7 x64 with SCCM 2007.

RE: [mssms] Need query help for TPM chip

2013-09-13 Thread Murray, Mike
If I run it as a report, I get this: An error occurred when the report was run. The details are as follows: Invalid object name 'SMS_R_System'. Error Number: -2147217865 Source: Microsoft OLE DB Provider for SQL Server Native Error: 208 If I run the query in SQL MGMT Studio, I get this:

[mssms] Run the *.msi application with .net framework 4.5

2013-09-13 Thread Rajan K
Dear all, I need to run a *.msi package and MS .Net Framework 4.5 with below condition , can anyone help me. Step: 1 - Check the .Net Framework 4.5 Installed status. Step:2 - If Net Framework 4.5 is No - It should install otherwise need to skip. Step:3 - Then install

RE: [mssms] Run the *.msi application with .net framework 4.5

2013-09-13 Thread Trevor Sullivan
Sounds like a good candidate for the ConfigMgr 2012 App Model. Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Rajan K Sent: Friday, September 13, 2013 12:20 PM To: mssms@lists.myitforum.com Subject: [mssms] Run the *.msi

[mssms] Powershell for Package and distribution point group

2013-09-13 Thread Todd Hemsell
If I wanted to remove a distribution point group from a package what powershell would I run? thanks, Todd

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Spinelli, Robert J
We're creating the computer object and assign lots of different variables to it for the task sequence, so the user is never prompted for anything. You wouldn't be able to get the same functionality if you used unknown computers is my assumption. No way to assign all the different variables per

RE: [mssms] Powershell for Package and distribution point group

2013-09-13 Thread Trevor Sullivan
PowerShell 3.0. Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Todd Hemsell Sent: Friday, September 13, 2013 12:48 PM To: mssms@lists.myitforum.com Subject: [mssms] Powershell for Package and distribution point group

RE: [mssms] Need query help for TPM chip

2013-09-13 Thread Trevor Sullivan
That's because there is not SQL Server view called SMS_R_System. That's the name of a WMI class. The equivalent of the SMS_R_System WMI class in SQL Server is the SQL Server view called v_R_System. Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Spinelli, Robert J
Jason, I think we have 2 options: 1) Import the machine using OSD (no MDT) and assign our computer variables, but we need to wait for the CAS collections to update which could be 5-10 mins. 2) Use unknown computers and there would be no wait for collections to update, but then we

Re: [mssms] Powershell for Package and distribution point group

2013-09-13 Thread Todd Hemsell
thanks for verifying. On Fri, Sep 13, 2013 at 1:17 PM, Trevor Sullivan tsul...@gmail.com wrote: I can’t seem to find a command that achieves that. Maybe in R2 of 2012.*** * ** ** Cheers, Trevor Sullivan ** ** *From:* listsad...@lists.myitforum.com [mailto:

RE: [mssms] Powershell for Package and distribution point group

2013-09-13 Thread Dzikowski, Michael
HA! From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sullivan Sent: Friday, September 13, 2013 1:50 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Powershell for Package and distribution point group PowerShell 3.0. Cheers, Trevor

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Spinelli, Robert J
So when you move the machine into the imaging collection you have the variables defined on the computer object or the collection? It sounds like you have it on the collection, unless I'm reading it wrong. If you have it defined on the imaging collection, you can't be very granular can you? I

RE: [mssms] Powershell for Package and distribution point group

2013-09-13 Thread Dzikowski, Michael
What about this: http://technet.microsoft.com/en-us/library/jj821906.aspx From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sullivan Sent: Friday, September 13, 2013 2:18 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Powershell for Package

RE: [mssms] Powershell for Package and distribution point group

2013-09-13 Thread Christopher.Catlett
LOL! 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

Re: [mssms] Powershell for Package and distribution point group

2013-09-13 Thread Todd Hemsell
I see the error of my ways! Let's try this :-) If I wanted to remove a distribution point group from a package what powershell COMMAND would I run? On Fri, Sep 13, 2013 at 12:50 PM, Trevor Sullivan tsul...@gmail.com wrote: PowerShell 3.0. ** ** Cheers, Trevor Sullivan **

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Marcum, John
It does make sense. I was doing something similar in 2007 and had to re-think things when I moved to 2012. I wasn't able to come up with a true zero touch solution. John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP

Re: [mssms] cleaning up AD after deleting a site

2013-09-13 Thread Todd Hemsell
You can delete everything in that container and it will recreate in under an hour. That is what I usually do to make sure only good boundaries are in there. On Fri, Sep 13, 2013 at 1:37 PM, Ryan Shugart rshug...@mii.com wrote: Hello: Quick question. I recently had a site server go

Re: [mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Todd Hemsell
what I did in CM07... I go through the entire wizard and I know what collection I should see the machine show up in. The last pane of the wizard calls a web service to see if the machine is a member of the collection yet. It calls once a minute until it comes back as True, then it exits and lets

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Jason Sandys
MDT will assign the variables based on MAC address - very similar to directly creating the variables on the objects in ConfigMgr. You simply add the MAC to the MDT DB and define the variables to set. Depending on what variables you are setting, you may need to extend the MDT DB, but that's

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Richard Zuraff
We do all the variables on the machine, except a few that apply to all machines that are on the collection as a backup. Just in case something happens with the variables on the machine. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Spinelli, Robert

[mssms] RE: cleaning up AD after deleting a site

2013-09-13 Thread Jason Sandys
Just the system container. You can safely delete everything in there and ConfigMgr (the current site) will (re-)create what it needs (restarting the site component manager [I think] will force this quicker also). J From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Spinelli, Robert J
Thanks John, we're having the same challenge, good to know were not alone. Thank you. Robert Spinelli | CTS | GTI | 575 Washington Boulevard, Jersey City, NJ, 07310, United States| T: +1.201.595.6820 | C: +1.917.538.6192 | robert.j.spine...@jpmchase.commailto:robert.j.spine...@jpmchase.com

Re: [mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Todd Hemsell
I can help with this but I need more info. What exactly are you trying to do? number of collections etc. On Fri, Sep 13, 2013 at 1:27 PM, Spinelli, Robert J robert.j.spine...@jpmchase.com wrote: Jason, ** ** I think we have 2 options: ** ** **1) **Import the machine

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Dzikowski, Michael
What about, adding the variables to your unknown computer collection? [cid:image001.png@01CEB08A.F9AD6970] From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Spinelli, Robert J Sent: Friday, September 13, 2013 1:51 PM To: mssms@lists.myitforum.com Subject:

RE: [mssms] Powershell for Package and distribution point group

2013-09-13 Thread Dzikowski, Michael
Nevermind that. From: Dzikowski, Michael Sent: Friday, September 13, 2013 2:21 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Powershell for Package and distribution point group What about this: http://technet.microsoft.com/en-us/library/jj821906.aspx From:

[mssms] cleaning up AD after deleting a site

2013-09-13 Thread Ryan Shugart
Hello: Quick question. I recently had a site server go bad on me, so ended up deleting and recreating the site with a new site code. Same boundaries, etc. The old site deleted from the SCCM console with no issues, but I have discovered the old site info didn't delete completely from

Re: [mssms] Powershell for Package and distribution point group

2013-09-13 Thread Todd Hemsell
I want to remove a package from the group, not a DP. it is very close but not quite... On Fri, Sep 13, 2013 at 1:21 PM, Dzikowski, Michael michael.dzikow...@ally.com wrote: What about this: http://technet.microsoft.com/en-us/library/jj821906.aspx ** ** ** ** ** ** *From:*

Re: [mssms] Powershell for Package and distribution point group

2013-09-13 Thread Ryan
I don't have time to write the code, but I saw a method that might do what you want...\ http://msdn.microsoft.com/en-us/library/hh948234.aspx RemovePackages on the SMS_DistributionPointGroup class On Fri, Sep 13, 2013 at 1:38 PM, Todd Hemsell hems...@gmail.com wrote: I want to remove a

RE: [mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Spinelli, Robert J
We are trying to make it so the user has to enter in the minimum amount of information to build a machine and the build starts quickly. Tech starts the image process up; we query some backend databases and pull all the variables we need. Power shell script would create the computer object in

[mssms] RE: cleaning up AD after deleting a site

2013-09-13 Thread Jason Sandys
Yep, yep. J From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Ryan Shugart Sent: Friday, September 13, 2013 2:11 PM To: mssms@lists.myitforum.com Subject: [mssms] RE: cleaning up AD after deleting a site Cool, so I can just delete anything with the old

[mssms] RE: cleaning up AD after deleting a site

2013-09-13 Thread Ryan Shugart
Great, thanks. Ryan From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Sandys Sent: Friday, September 13, 2013 1:15 PM To: mssms@lists.myitforum.com Subject: [mssms] RE: cleaning up AD after deleting a site Yep, yep. J From:

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Spinelli, Robert J
Makes sense, thanks Richard. Thank you. Robert Spinelli | CTS | GTI | 575 Washington Boulevard, Jersey City, NJ, 07310, United States| T: +1.201.595.6820 | C: +1.917.538.6192 | robert.j.spine...@jpmchase.commailto:robert.j.spine...@jpmchase.com From: listsad...@lists.myitforum.com

Re: [mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Todd Hemsell
show up in the imaging collection for 5 minutes you start to query if the machine is a member yet. do you get the resourceID back when you create the computer? If so Select Name from V_FullCollectionMembership where CollectionID = XXXMyCollection AND ResoureID = 234562 When your return row

[mssms] RE: WSS for CM12 DP?

2013-09-13 Thread Marcum, John
Are you using 2008 or 2012? I'm not currently but I am considering it so I'd be interested to know more about this as well. The docs do not list 2012 as being supported John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP

[mssms] RE: Add machines to collections - OSD Slow - CAS

2013-09-13 Thread Marcum, John
I agree. Using the MDT database sounds like the best alternative to me. John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of

[mssms] RE: WSS for CM12 DP?

2013-09-13 Thread Patel, Hitesh N
We have DP and SMP role installed on a storage device that happens to be running 2008 essentials. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: Friday, September 13, 2013 4:01 PM To: 'mssms@lists.myitforum.com' Subject: [mssms] RE:

[mssms] RE: WSS for CM12 DP?

2013-09-13 Thread Marcum, John
Is the SMP role supported on that OS? John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Patel, Hitesh N Sent: Friday,

[mssms] RE: UEFI boot sccm 2007 + mdt 2010

2013-09-13 Thread Michael Niehaus
MDT 2010 and ConfigMgr 2007 won't handle UEFI. You would need to move to MDT 2012 Update 1 and/or ConfigMgr 2012 SP1 CU2 or above to get a good UEFI experience. Running Windows 7 using UEFI doesn't really buy you much, although you may want to do it anyway if you want to later move to Windows