nhottinger

Is there a way to write this so I can select the device collection to take the inventory from first? I'm asked for this info a lot of times from specific departments and I'm tired of manually going through the full inventory list and weeding them out.

Here is my query. I would think it would pull every device it knows of, even if it can't do a hardware inventory on it. Am I wrong? SELECT distinct CS.name0 as 'Computer Name', CS.domain0 as 'Domain', CS.UserName0 as 'User', BIOS.SerialNumber0 as 'Bios serial', SE.SerialNumber0 as 'System Enclosure serial', CS.Manufacturer0 as 'Manufacturer', CS.Model0 as 'model', OS.Caption0 as 'OS', RAA.SMS_Assigned_Sites0 as 'Site', RAM.TotalPhysicalMemory0 as 'Total Memory', sum(isnull(LDisk.Size0,'0')) as 'Hardrive Size', sum(isnull(LDisk.FreeSpace0,'0')) AS 'Free Space', CPU.MaxClockSpeed0 as 'Max CPU Speed', CPU.Name0 as 'CPU Model', CPU.Is64Bit0 as '64 Bit Compatible' from v_GS_COMPUTER_SYSTEM CS right join v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceID right join v_GS_SYSTEM SYS on SYS.ResourceID = CS.ResourceID right join v_GS_OPERATING_SYSTEM OS on OS.ResourceID = CS.ResourceID right join v_RA_System_SMSAssignedSites RAA on RAA.ResourceID = CS.ResourceID right join V_GS_X86_PC_MEMORY RAM on RAM.ResourceID = CS.ResourceID right join v_GS_Logical_Disk LDisk on LDisk.ResourceID = CS.ResourceID right join v_GS_Processor CPU on CPU.ResourceID = CS.ResourceID right join v_GS_SYSTEM_ENCLOSURE SE on SE.ResourceID = CS.ResourceID where LDisk.DriveType0 =3 group by CS.Name0, CS.domain0, CS.Username0, BIOS.SerialNumber0, SE.SerialNumber0, CS.Manufacturer0, CS.Model0, OS.Caption0, RAA.SMS_Assigned_Sites0, RAM.TotalPhysicalMemory0, CPU.MaxClockSpeed0, CPU.Name0, CPU.Is64Bit0 ORDER BY CS.name0

Thanks Peter. After some more digging and trial and error, I figured out how to create a new report based on some I found out there. Seems to be working pretty well. After I ran the report, I notice it only returned 1857 devices. In my SCCM All Workstation or Professional Systems, I have 2353 devices. Any idea why there is such a large difference?

I need to provide management a report of every pc we have in the organization with how much RAM, CPU, HD, Model Number, etc. Is there a report already build that will do that? I'm not familiar with creating new reports so if that is the route I need to go, I will need some assistance with that as well.

I'm trying to get a handle on Adobe Reader, Flash and Java updates through SCCM 2012 using WSUS. Is there an easy way other than downloading the updates and deploying them? I'd like to do these updates at the same time I do Patch Tuesday updates through SCCM Software Update Groups. I've not looked into Solar Winds yet. In my limited experience, pushing Adobe and Java through application deployments doesn't always work as I would expect.

Our organizations pc's have Adobe Reader 11.0.06 on them and I need to update them to 11.0.09. I downloaded the msp for 11.0.09 but when I deploy it, it fails. If I try to run the update manually on the pc I get an error "The update patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch." What am I doing wrong?

I have installed everything from all the guides, but I'm not sure it's working correctly. I now have the Dell Warranty option in the SCCM console, but when I click on it for a device, no information shows up. Any idea what I'm missing? I'm able to run a report from the Report manager and everything shows up there just fine, just not in the console.

Thanks everyone, I appreciate it.

This should work for us. Do you know how often this updates? We would like something that is updated as soon as a user logs into a specific device.

I'm looking for a way to either run a script, or query SCCM to find the device that a user last logged into. I know about device affinity, but that is not what I'm looking for. I need a way to find out what pc a user had used last. I found this topic, but don't know how to implement it into SCCM or as a query. http://www.techygeekshome.co.uk/2013/01/last-logged-on-user-query-all-systems.html

We are a full windows shop with Dell computers. We use GPO and a login script to map printers for specific pc's. Recently we have had more and more domain pc's installing printers that are not even in the area of this pc. The pc or user are not members of the group that should get these printers. We have checked all the GPO's we can think of, but it seems like everyday there is another pc getting these printers installed. Does anyone have an idea of what is happening here? Here is an example of the script that we are running. Option Explicit dim WshNetwork Sub printers Set WshNetwork = CreateObject("WScript.Network") WshNetwork.AddWindowsPrinterConnection \\SERVER\PR03 WshNetwork.SetDefaultPrinter \\SERVER\PR03 WshNetwork.AddWindowsPrinterConnection \\SERVER\PR02 End Sub Call printers

Peter, the link you provided does not work but I was able to find what I needed. Maybe I'm reading it wrong, but it doesn't look like there is functionality to have the warranty info listed next to the pc in a device collection. Do you know if this is possible? If not, I can make it work, but I'd really like to see that so I can just sort by date and export the ones I need.

Thanks for the info GarthMJ. I'm not necessarily looking for a free solution, I'm looking for a solution that works. Have you ever used the Dell Client Integration Pack? Or know anything about it? I'll be looking into the WIR. What is the cost for a product like this?

I've been looking into finding a way to pull the warranty info of our pc's into SCCM. I found the Dell Client Integration Pack but don't know much about it. Does it work as it is advertised? Any gotcha's I need to know about before installing it on our SCCM server? Any tips? Does it actually pull the warranty of every Dell device and show in SCCM or some report? Sorry for so many questions, just don't know anything about it yet but it sounds like it could save me a bunch of time each year trying to provide replacement numbers to management.

I was able to find what I was looking for. On the reports server, I ran a Asset Intelligence / Hardware 09A - Search For Computers and was able to retrieve the model number. Now if only there was a way to get the warranty date into SCCM I'd be golden.

I'm asked each year to provide a list of pc's for upper management that need replaced. Each year I dread this and work through it with the information I have but it's never really that good. Is there an easy way with SCCM 2012 to run a report of pc's based on model, or better yet, warranty expiration? Usually model gets me close enough since I know they order they were purchased in. We have Dell desktops and laptops, and a few Panasonic and Fujitsu tablets. Any advise or help is appreciated.

I was able to use the Command line installation tool built into the trend micro encryption software and it was working just fine when I put that command into a task sequence. We upgraded to SP1 of the TMEE software and now it doesn't work. I have completely rebuilt the task sequence and SCCM says it installs correctly, but it never actually installs the software. Is there a log file I can look at to see what is going on? If I log into the pc and paste the command line created from the TMEE server it runs just fine, and installs the software. But it will not work when called via a task sequence.

Sorry for my ignorance, but how do I use this? I attempted to paste this into a query rule but got errors.

I've looked around a bit but have yet to come up with a good query or report to show the number of physical processors on our servers. Can anyone help?

Thank you. I'll take a look at it. I really appreciate it.

I think your a little above my head Peter. I'm not sure how to do that.

I have yet to get the .exe to actually install. I don't do many this way as the .msi method is so much easier. Even if I get it to install with the .exe, there are some settings that need configured during the install (Enterprise name, username / password, server). Not sure how to get those set during the install without manual intervention.

Has anyone tried or been successful deploying Trend Micro Full Disk Encryption with SCCM2012? Here is what I have tried: Created an .msi from the .exe provided (including all settings needed when originally installing) Deployed .msi via SCCM to a test pc. Deployment was successful but the encryption process does not ever start, even after a reboot. The DrAService.exe is running, but eventually an error comes up that says it can't communication with the Trend Micro Encryption service. Any suggestions? We have about 2,000 devices to encrypt and I don't want to have to manually touch each and every one of them if I don't have to.

I'm attempting to add updates to our existing images and I keep getting the same error on every image. Error: The SMS Provider reported an error. Nothing in the OfflineServicingMgr.log either that indicates a problem.

Can someone help with the steps to get my RTM environment upgraded to the newest / latest version of SCCM2012? Do I need multiple upgrades or is there a direct path?