CraigSCCM

Hi thanks for the reply Nick, your script isn't really going to work for me, as there are 500 Users in this Collection (i didn't create this, they were added in manually by someone *sigh*) is there no way to get the Primary Computer Device for each user in that collection, either by a Query or script

Hey guys, I've run into a brick wall with this one I have a User Collection which has 500 members in, I would like to export this collection to csv containing all the primary devices which are linked to what user? Is this possible with CM Powershell or a Query...any help would be greatly appreciated Thanks

I've managed to solve the issue It turns out that the capture disk I was using contained the wrong boot image for the type of machine I was trying to capture So I created a new x86 Boot image, injected the NIC Drivers into the wim, created a new capture media and success it works

Hi guys, I've got an issue capturing one of our latest machines I've attached the log file below The Error comes up with "Failed to run the action: Capture the Reference Machine. The network location cannot be reached. For information about network troubleshooting, see Windows Help. Error: 800704CF" Is this something to do with the Network Access account, because we have 3 accounts in our NAA, I thought it would fall back onto either one, if the first one failed? or is this something else? Any help would greatly be appreciated thank you smstslog.txt

thanks niall, how would I do it through config mgr 2012 R2?

Hi guys, I have a question i'm hoping someone can help me please Can you build a machine with Windows 8.1, enable the Hyper-V Feature and build a Windows 7 VM? Doing this all through the task sequence, which will need to be rolled out for 500 Machines, having both Operating Systems on the domain and a it gives a unique computer name (for the Windows VM) Is this possible all through SCCM?? Thank you

i had a similar issue, my TS was working perfectly for a while then i had a problem where only 1 of my 5 applications were being installed during the task sequence, the other 4 would not install, it would time out, i literally had no idea how to fix it, so i rebuilt my TS and it just seemed to work :-/

Hi, you will need to give it some time to come back with any useful results, it will need a months worth of data before you will have anything you can work with.

Hi guys, I've packaged up an Uninstall batch script and i'm using the following command in the .batch file @ECHO OFF msiexec.exe /X{26A24AE4-039D-4CA4-87B4-2F83218045F0} /qn /norestart then in my command line in SCCM i have: runas /user:"Administrator" uninstall.bat I have tried it with just uninstall.bat and that still didn't work :-( I have attached my AppDiscoveryLog Any help is much appreciated - thank you in advance Craig

Thank you Peter, i think i will stick with the way i've got things currently set up and use Device Collections

i have the same settings and wish to change my username if possible please

i'm just trying to think of a few benefits where i would actually need to use a "User Collection" instead of a "Device Collection" It seems Device collections are a lot easier to deploy software out too, and pushing out user software to user collections just seems to be a pain? deploying to a user collection, does the software disappear if the user doesn't log into that computer again? can some body clear this up please

smsts-20150521-115237.log I built a Windows 10 Image, went to capture it using Sys Prep, but it failed i don't now why It;s exactly the same way i did all the windows 7 & 8.1 builds The SMSTS log display a tonne of errors Sys Prep did not complete successfully Error 80004005 Exiting error code 16389 SMSTS Log attached Any help would be greatly appreciated Thank you

SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS_64 where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Microsoft Visio Standard 2010") that's the part it had to add in

Thank you mate, i've done it I didn't realise you have to specify for x64

Hi guys, i'm currently going through a load of Licenses to remove MS Visio from users that don't need it anymore So i ran a Software Metering Report for "Computers that have a metered program installed but have not run the program since a specified date" Created an uninstall package and it removed ones from a specific date etc, that's fine..... I have just ran a Query and a Report Here's my Query: select distinct SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.MACAddresses from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Visio Standard 2010" order by SMS_R_System.Name This Query brings back 68 Results of people that have Visio Installed I then ran this report "Software - Companies & Products - Computers with a specific software registered in Add Remove Programs" This report brings back 136 Results for people that Still have visio installed Now i know full well i've removed it off about 50 people, but neither reports/queries are giving me correct information? And they both are pointing to "Microsoft Visio Standard 2010" - so i'm really stumped as to what's going on? How do i go about forcing a software refresh or cycle so it will give me the correct data? Thanks

Hello, i have done a similar Package deployment of a bios password to all our HP Machines, (2500+) Using the below command biosconfigutility /nspwd:"PASSWORD" I got the tool from the HP Site, and made a query for the collection, so any new PC's that get imaged, automatically get the Bios Password instead of re-deploying Here's the Query below select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model = "HP Compaq 6005 Pro MT PC" or SMS_G_System_COMPUTER_SYSTEM.Model = "HP Compaq Pro 6305 MT" or SMS_G_System_COMPUTER_SYSTEM.Model = "HP Compaq Pro6305 Microtower" Hope that helps

thank you for your help GarthMJ

Hi GarathMJ, how come this won't pull the relevant information down? Have i missed something on the query? Thanks

Hi mate, thank you very much for this, i slightly modified yours and i got the results i need, here is mine select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Microsoft Office 2010%") and SMS_G_System_COMPUTER_SYSTEM.SystemType = "X86-based PC"

Hi simulacra75, thank you for the reply, i have seen that before, but i'm not sure how to intergrate it into a query or report?

Hi guys, I need to find all workstations in our Organization that have Office 32bit installed All of our Clients have x64 OS and x64 Office, but some (before i started the company) have 32bit Office installed I have searched the web, and found a couple of queries but they didn't pull any information down Any help would be greatly appreciated Thanks