[mssms] OT: Group policy/permissions to change subdomain

2017-08-31 Thread Mike Murray
I’m hoping someone here will know. We have a test domain, let’s say “myschool.edu” which is a problem. We can’t use the default dns settings. We would like our workstations to consistently resolve with the dns suffix “ad.myschool.edu”. They don’t now use their own machine name. We want to

[mssms] RE: Report clocking. Used to work in 2007 but not in CB

2017-08-31 Thread Garth Jones
This query will work in CMCB but only if you added the user discovery items to it, PLUS you really need to change the Full outer joins to inner joins. Did you upgrade SQL Server version recently? I used one of the Query formatter https://www.enhansoft.com/blog/query-formatting-tools to make

RE: [mssms] Computer management for different vendors

2017-08-31 Thread Daniel Ratliff
Lenovo is terrible. Although their Systems Management has improved in the last year, its still leaps and bounds behind HP and especially Dell. · ThinkVantage Updater · ThinInstaller · SCUP catalog · SCCM CABs from the support site · Direct downloads

RE: [mssms] Computer management for different vendors

2017-08-31 Thread Thelen, Chris
Never dealt with HP. But we currently use Dell and Lenovo hardware. Dell has done a lot of good work for making SCCM management easy. They have a specific website that has all of the driver packages available and the WinPE driver packs. Dell has ditched the Warranty tool in the SCCM add-in,

RE: [mssms] List of Computers From Users

2017-08-31 Thread Daniel Ratliff
I usually throw it in Excel and do this. PC01 'PC01', PC02 'PC02', PC03 'PC03', The formula on B column is =CONCATENATE("'",A1,"',") Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger Sent: Thursday, August 31, 2017

RE: [mssms] TPM, BitLocker, and ConfigMgr

2017-08-31 Thread ben.smith
Yeah I think all l.p. the same links had me believing the same thing for a long time. It wasnt until we needed to automate things more to ensure a consistent build process that I found how to clear it programmatically. The wmi stuff wasn't easy to find at the time. Sent from my Verizon 4G

Re: [mssms] Computer management for different vendors

2017-08-31 Thread Stuart Watret
Currently sick of HP, but not sure if other vendors are any better. Escalation here in the UK is hit and miss. Mainly driver issues, HP will say it supports this OS, drivers from HP don’t support that OS, so you run around getting vendor drivers. And I’m sure this isn’t just HP, but I’m really

Re: [mssms] TPM, BitLocker, and ConfigMgr

2017-08-31 Thread Mike Dougherty
I was basing my statement on these, but according you folks, they might not be entirely accurate anymore: http://en.community.dell.com/techcenter/systems-management/f/4469/t/19460941 http://en.community.dell.com/techcenter/enterprise-client/f/4448/t/19578726 On Thu, Aug 31, 2017 at 12:55 PM,

RE: [mssms] TPM, BitLocker, and ConfigMgr

2017-08-31 Thread John Marcum
Dell (and others) have tools to do this. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Mike Dougherty Sent: Thursday, August 31, 2017 12:25 PM To: mssms@lists.myitforum.com Subject: Re: [mssms] TPM, BitLocker, and ConfigMgr My understanding is that by

Re: [mssms] List of Computers From Users

2017-08-31 Thread Sherry Kissinger
close-ish... but it'll have a missing ' at the front, and extra ,' at the end. but maybe this'll be close enough. or you can tweak it more. select name0 + ''',''' from v_r_system for xml path('') On Thu, Aug 31, 2017 at 1:10 PM, John Marcum wrote: > I have a list

[mssms] Computer management for different vendors

2017-08-31 Thread ben.smith
My company is looking at possibly changing computer vendors so I am just wonder what peoples experiences have been when managing computers with SCCM from different vendors, Dell/HP/Lenovo. Have you had any pain points with any of the OEMs? Any experiences that were particularly good or bad

[mssms] List of Computers From Users

2017-08-31 Thread John Marcum
I have a list of user name and I need to get the computer names for them. That's easy enough but I'd like to not have to enclose all the computer names in single quotes manually (I need to ultimately get these computers into collections as direct memberships) Is there a way to manipulate the

Re: [mssms] TPM, BitLocker, and ConfigMgr

2017-08-31 Thread Nick sullivan
In our Task Sequence we do the following for HPs' and Lenovos' [cid:7dda01d2-9aeb-4081-b4af-d2118bafa1d0] Lenovo we use the internet famous script called "DotheMagic.vbs" http://www.purgar.net/configmgr-how-to-enable-tpm-on-lenovo-computers-during-osd/

RE: [mssms] TPM, BitLocker, and ConfigMgr

2017-08-31 Thread Jeff Poling
Thanks! This really helpful! Sent from my Windows 10 phone From: ben.sm...@everestre.com Sent: Thursday, August 31, 2017 1:05 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] TPM, BitLocker, and ConfigMgr That’s not quite

RE: [mssms] TPM, BitLocker, and ConfigMgr

2017-08-31 Thread ben.smith
That’s not quite true. I am using a powershell script to manipulate WMI to clear it programmatically. I am pretty sure I copied the script form someone else but can’t find the source right now. There also seems to be a better way provided by Microsoft, see below, but I haven’t tried it yet.

Re: [mssms] Report clocking. Used to work in 2007 but not in CB

2017-08-31 Thread Sherry Kissinger
It's probably more to do with your SQL config than with CM. Nevertheless, I re-wrote it anyway. This took 19 seconds to run for me, against a collection with 100k boxes in it. took 8 seconds against a collection with 100 boxes in it. If the below still just runs/never finishes, you're going to

Re: [mssms] TPM, BitLocker, and ConfigMgr

2017-08-31 Thread Mike Dougherty
My understanding is that by TPM design/spec/whatever is that can't be cleared programmatically and must be with manual user interaction in the BIOS/Setup menus. https://trustedcomputinggroup.org/tpm-main-specification/ On Wed, Aug 30, 2017 at 8:06 PM, Jeff Poling

[mssms] Report clocking. Used to work in 2007 but not in CB

2017-08-31 Thread Burke, John
HI, This report works on smaller collections, but when I bump it up to all systems (with 5) systems it just runs for hours and hours and never ends. It runs on collections with 7000 or so in them. Is there something busted in it? I basically want a row for every pc in the collection no