Re: [mssms] Help shape a right click tool!

You have to watch out with triggering something like that in a task sequence. The client is set for an Automatic (Delayed) Start, so you usually have to wait up to 5 minutes before you can trigger one of the policies after a restart. If you try to trigger it before the service starts, or right

[mssms] Wipe the PGP MBR in a task sequence

I have an in-place refresh task sequence with USMT for upgrading XP to win7. Our XP clients are all encrypted with Symantec Encryption Desktop (formerly PGP) v10.3. Symantec provides instruction for adding the PGP drivers to the WinPE image, and that works. My task sequence is initiated via

[mssms] Get the SYSTEM_OU_NAME without the duplicate rows

Does anyone have any SQL Fu handy that will give you the longest value in the dbo.v_RA_System_SystemOUName? Trying to put together a report where I want to add the OU a system is in but that view has separate rows for each sub ou a given system is in. Jeff Krueger IT - Endpoint Design

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

I literally had the same issue last week, and just filtered in Excel for the sake of time. Would love to see some SQL magic to do the trick. Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Krueger, Jeff Sent: Tuesday, April 22, 2014

RE: [mssms] Get the SYSTEM_OU_NAME without the duplicate rows

I wrote a stored procedure to do that, it was the easiest way for me. I can get that and post if wish. Rick J. Jones Wireless from ATT Domestic Desktop Application Management D: (425) 288-6240 C: (206) 419-1104 From: Krueger, Jeffmailto:jkrue...@hfhs.org Sent:

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

I had a report somewhere for that. I'll see if I can dig it up... -Phil From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Tuesday, April 22, 2014 11:32 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: Get the SYSTEM_OU_NAME

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

Older (CM07), but still applicable logic: http://www.systemcentercentral.com/sccm-reportingadding-the-system-ou-as-a-column/ From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Schwan, Phil Sent: Tuesday, April 22, 2014 11:40 AM To:

Re: [mssms] Wipe the PGP MBR in a task sequence

Can you initiate the userstate store while in windows? Then just usb boot the machine and nuke the disk (without loading the pgp drivers). You would have to add a variable or two to the TS, so it would run as a refresh, and would know where the userstate was stored to. 3rd party encryption

RE: [mssms] Wipe the PGP MBR in a task sequence

My manager wants it all done in a single TS, where the technicians can kick it off and walk away. -Kenneth From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of christopher.catl...@us.sogeti.com Sent: Tuesday, April 22, 2014 10:43 AM To:

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

Give this a try. select sys.Netbios_Name0, isnull(max(ou.System_OU_Name0), SC.System_Container_Name0) from v_R_System_Valid sys left outer join v_RA_System_SystemOUName ou on sys.ResourceID = ou.ResourceID left outer join dbo.v_RA_System_SystemContainerName SC on

Re: [mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

select FieldName from daTable where length(FieldName) = ( select max(length(FieldName)) from daTable ) or ORDER BY LENGTH(FieldName) DESC and use LIMIT 1 Sent from Windows Mail From: Daniel Ratliffmailto:dratl...@humana.com Sent: ‎Tuesday‎, ‎April‎ ‎22‎, ‎2014 ‎11‎:‎56‎ ‎AM To:

[mssms] How to handle drivers multiple reboots

Am into drivers integration task for my sccm 2007 and 2012... I have enabled default step auto apply drivers and do not have any PNP drivers in my TS.. All are the exe based drivers and tested manually with all my command lines and working fine. Now the issue is after apply WIM image it

Re: [mssms] How to handle drivers multiple reboots

use apply dirver package instead of auto apply drivers, and use WMI to detect what the hardware is, like herehttp://www.windows-noob.com/forums/index.php?showtopic=563(same process in cm12), as regards the reboots, what does your smsts.log file tell you about that ? a good idea (when

Re: [mssms] How to handle drivers multiple reboots

Exe based drivers wont work for network or mass storage, those need to be “real” drivers. also you need to suppress the reboots that your driver installs are doing. You may have to extract the “bad” drivers. Sent from Windows Mail From: Niall Bradymailto:any...@gmail.com Sent: ‎Tuesday‎,

RE: [mssms] Wipe the PGP MBR in a task sequence

It's basically impossible to do a refresh of a machine with third party encryption in a single task. Managers want all sorts of things, some of them just can't be done. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Merenda, Kenneth Sent: Tuesday,

Re: [mssms] Wipe the PGP MBR in a task sequence

Marcum is right, messing with 3rd party ecryption, is a royal PITA. Some things just arent possible…… you can fully decrypt the disk, or do it another way. Sent from Windows Mail From: jmar...@babc.commailto:jmar...@babc.com Sent: ‎Tuesday‎, ‎April‎ ‎22‎, ‎2014 ‎1‎:‎27‎ ‎PM To:

RE: [mssms] Wipe the PGP MBR in a task sequence

Silly question here but … If you blow the entire disk away how will it know where to pick up in the task sequence when the machine reboots? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Merenda, Kenneth Sent: Tuesday, April 22, 2014 10:51 AM To:

RE: [mssms] Wipe the PGP MBR in a task sequence

Also note, just because its not a single task sequence does not mean it cant be ‘kicked off and walk away’. We do our ZTI migrations with a backup TS that adds the machine to a collection, reboots to PXE, and runs a 2nd task sequence. All one click. Daniel Ratliff From:

Re: [mssms] How to handle drivers multiple reboots

Ok... Thank you ... I will try once again with Niall ur suggestions Sent from iPhonesorry for typos On 22-Apr-2014, at 10:46 pm, christopher.catl...@us.sogeti.com wrote: Exe based drivers wont work for network or mass storage, those need to be “real” drivers. also you need to

RE: [mssms] Wipe the PGP MBR in a task sequence

Daniel – How do you get it to reboot to PXE? If I could do that, I’d be set. The TS can’t download the boot image because it would be stored on the encrypted drive, but if the TS could reboot and then load the boot image over PXE, that would be perfect. -Kenneth From:

RE: [mssms] Wipe the PGP MBR in a task sequence

One cool thing if you are using the SMP…..You need not do anything special to restore the data when doing two separate TS's. CM will see it's a bare metal on the same hardware that has data in the SMP and put it back. I didn't like using the SMP so I used a UDI wizard to point to the share

RE: [mssms] Wipe the PGP MBR in a task sequence

Most of our hardware is Lenovo, so we just change the boot order via WMI/scripts with the backup TS. Our PXE boot is handled by 1E PXELite though, not WDS. We used Symantec Endpoint Encryption, backup all data to the network with the backup TS, reboot to PXE, wipe the drive and deploy from

Re: [mssms] Sccm client deployment with imaging

your captured image does NOT need to have the client installed, you could captured it using capture media (iso or cd), mdt or imagex. You can deploy that captured image (reference image) with a configuration manager task sequence that installs the client as part of the task sequence. On Tue, Apr

RE: [mssms] Sccm client deployment with imaging

Just to clarify though, if you are using a ConfigMgr task sequence to both create and capture the image, then yes it will have the client in the core image. Unless you have very specific concerns though, if you are deploying that image via ConfigMgr you should not have any issues. -Phil

Re: [mssms] Sccm client deployment with imaging

you can of course build an image with configuration manager, then uninstall the client (ccmsetup /uninstall) then capture that image using whatever method you wish, and this will be a configuration manager built image but minus the client. On Tue, Apr 22, 2014 at 8:28 PM, Schwan, Phil

Re: [mssms] Sccm client deployment with imaging

We actually capturing from MDT in a lab... And the captured gold WIM is used to deploy in production with SCCM in this case do I have sccm client automatically deployed Even though I have not included in MDT capture task sequence step... Sent from iPhonesorry for typos On

RE: [mssms] Sccm client deployment with imaging

Of course you CAN…. ;) -Phil From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Niall Brady Sent: Tuesday, April 22, 2014 2:45 PM To: mssms@lists.myitforum.com Subject: Re: [mssms] Sccm client deployment with imaging you can of course build an image with

RE: [mssms] Sccm client deployment with imaging

If you’re capturing in standalone MDT, there is no ConfgMgr client involved so it will not be in the image. When you deploy that image in ConfigMgr, the ConfigMgr client must necessarily be installed during the image process. This is true regardless of whether you have MDT integration. -Phil

Re: [mssms] Sccm client deployment with imaging

So the client will be installed automatically when deployed in sccm ? Sent from iPhonesorry for typos On 23-Apr-2014, at 12:31 am, Schwan, Phil psch...@projectleadership.net wrote: If you’re capturing in standalone MDT, there is no ConfgMgr client involved so it will not be in the

RE: [mssms] Sccm client deployment with imaging

Yes, during the Setup Windows and ConfigMgr step. Cheers, Trevor Sullivan Microsoft PowerShell MVP From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Hun boy Sent: Tuesday, April 22, 2014 2:15 PM To: mssms@lists.myitforum.com Subject: Re: [mssms]

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

Thanks, I got the example on the blog working, with the below query. select dbo.v_R_System_Valid.Netbios_Name0, (select top 1 ou2.System_OU_Name0 from v_RA_System_SystemOUName ou2 where ou.ResourceID = ou2.ResourceID and LEN(ou2.System_OU_Name0) = MAX(LEN(ou.System_OU_Name0))) OU from

RE: [mssms] Wipe the PGP MBR in a task sequence

I’m doing this right now. It’s not impossible. We’ve currently migrated over 5000 windows xp workstations to windows 7 without Decrypting, or using any 3rd party product. The trick is to not only add the PGP drivers to your PE Boot Image, but also capture a Windows 7 image with PGP installed

RE: [mssms] Wipe the PGP MBR in a task sequence

One thing to note, we’re actually migrating our end users data, so not actually formatting the hard disk. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Joshua Searles Sent: Tuesday, April 22, 2014 1:55 PM To: mssms@lists.myitforum.com Subject: RE:

RE: [mssms] Wipe the PGP MBR in a task sequence

Bootrec /fixmbr from the windows recovery CD will do what you’re doing, but I haven’t tried to incorporate that into the PE Boot Image. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Merenda, Kenneth Sent: Tuesday, April 22, 2014 8:51 AM To:

[mssms] Bitlocker step OSD TS

I have a system enabled with bitlocker. Now when I want to do the deployment of windows again is it mandatory to use disable bitlocker step ??? What happens if I do not use this step and proceed further to deploy OS ? Sorry about questions am trying to understand the practical problems...

Re: [mssms] Bitlocker step OSD TS

if you want to reinstall Windows again then you would normally disable bitlocker (you can disable bitlocker in the Windows OS itself and then reboot, or disable it in WinPE as I do below). When you are doing a re-installation of Windows (a refresh), keeping the users data is important, and if the