Jump to content


thekurgan1536

Established Members
  • Posts

    11
  • Joined

  • Last visited

Everything posted by thekurgan1536

  1. Thanks Garth. I've inherited an existing system and that's how it was configured. I'll take a look at your link and try to go from there.
  2. Hi guys. Running sccm 2012, version 5.00.8239.1000, build number 8239. Due to our environment and severally behind code from our internal coders, we have to use an older version of IE for many of our custom apps. We're trying to get a count of each IE version running in the environment across the country. Specifically our desktops (servers don't matter for this). I'm using the All Desktop Clients collections which has 5407 clients in it. Majority of the clients (like 98%) report in active. Because I don't trust my query building skills, I found Anoop's sql one. https://www.anoopcnair.com/2015/10/19/sccm-configmgr-2012-sql-query-to-find-out-ie-version-with-os-details-of-workstations/. His query searches all systems I believe, but it can be used to filter out servers afterwards. I only come up with about 431 clients after running it roughly. It's about 471 clients if I don't modify his query. Software inventory for all exe's has been enabled for years. So it's not that. Does anyone have any steps to take to identify the issue? Thanks,
  3. Oi. That was what I needed to do. Didn't even think of that.
  4. Hi Garth, That def. was the issue. I'm starting to get some data. This is the sql statement I'm using: SELECT DISTINCT TOP (100) PERCENT SYS.Netbios_Name0 AS 'Server', Processor.Name0, Processor.NormSpeed0 AS [CPU Speed], Processor.DeviceID0, ProcAddtl.NumberOfCores0 AS [Number of Cores], ProcAddtl.NumberOfLogicalProcessors0 AS [Number of Logical Processors], dbo.v_GS_OPERATING_SYSTEM.Caption0 AS 'OS', dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 AS 'Vendor' FROM dbo.v_R_System AS SYS INNER JOIN dbo.v_GS_PROCESSOR AS Processor ON SYS.ResourceID = Processor.ResourceID INNER JOIN dbo.v_GS_X86_PC_MEMORY ON SYS.ResourceID = dbo.v_GS_X86_PC_MEMORY.ResourceID INNER JOIN dbo.v_GS_OPERATING_SYSTEM ON SYS.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID INNER JOIN dbo.v_GS_COMPUTER_SYSTEM ON SYS.ResourceID = dbo.v_GS_COMPUTER_SYSTEM.ResourceID LEFT OUTER JOIN dbo.v_GS_Processor_Addtl0 AS ProcAddtl ON Processor.ResourceID = ProcAddtl.ResourceID WHERE (dbo.v_GS_OPERATING_SYSTEM.Caption0 LIKE '%Server%') AND (dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 = 'VMware, Inc.') ORDER BY 'Server' And the output (changed the server names): SST018 Intel® Xeon® CPU X5660 @ 2.80GHz 2800 CPU1 NULL NULL Microsoft® Windows® Server 2003, Standard Edition VMware, Inc. TTAD01 Intel® Xeon® CPU X5660 @ 2.80GHz 2800 CPU0 NULL NULL Microsoft® Windows® Server 2003, Standard Edition VMware, Inc. TTAD01 Intel® Xeon® CPU X5660 @ 2.80GHz 2800 CPU1 NULL NULL Microsoft® Windows® Server 2003, Standard Edition VMware, Inc. TTAD01 Intel® Xeon® CPU X5660 @ 2.80GHz 2800 CPU2 NULL NULL Microsoft® Windows® Server 2003, Standard Edition VMware, Inc. TTAD01 Intel® Xeon® CPU X5660 @ 2.80GHz 2800 CPU3 NULL NULL Microsoft® Windows® Server 2003, Standard Edition VMware, Inc. RSTAD01 Intel® Xeon® CPU E5-2665 0 @ 2.40GHz 2400 CPU0 NULL NULL Microsoft® Windows® Server 2003, Standard Edition VMware, Inc. RSTAD01 Intel® Xeon® CPU E5-2665 0 @ 2.40GHz 2400 CPU1 NULL NULL Microsoft® Windows® Server 2003, Standard Edition VMware, Inc. HRSMS021 Intel® Xeon® CPU E7420 @ 2.13GHz 2130 CPU0 1 1 Microsoft® Windows Server® 2008 Standard VMware, Inc. HRSMS021 Intel® Xeon® CPU E7420 @ 2.13GHz 2130 CPU1 1 1 Microsoft® Windows Server® 2008 Standard VMware, Inc. HRSMS112 Intel® Xeon® CPU X7560 @ 2.27GHz 2270 CPU0 1 1 Microsoft Windows Server 2008 R2 Standard VMware, Inc. HRSMS112 Intel® Xeon® CPU X7560 @ 2.27GHz 2270 CPU1 1 1 Microsoft Windows Server 2008 R2 Standard VMware, Inc. HRSMS112 Intel® Xeon® CPU X7560 @ 2.27GHz 2270 CPU2 1 1 Microsoft Windows Server 2008 R2 Standard VMware, Inc. HRSMS112 Intel® Xeon® CPU X7560 @ 2.27GHz 2270 CPU3 1 1 Microsoft Windows Server 2008 R2 Standard VMware, Inc. Is there a way to rewrite it so that it gives the totals for each server like Sherri created in report (the above link)? Her query is for one computer, I would like to show all computers, but with one entry per line.
  5. Correct, CM07. I meant to include that in my initial post for clarification. Ok. Let me see if I can force it on some test machines. If that is the case, I'll feel a "little" better.
  6. That's what I was trying to test by creating a report in sql for. I figured if I could at least see the new table (Processor_Addtl) in sql and it had zero data, that was a good start. Then I could at least initiate a hardware scan and the review the query to make sure something was being pulled. But when I build the query in Views, I don't see it listed under Tables or Views. Which is why I'm either blind as a bat searching for the table or I have clearly missed several steps I'm not aware of that I must do.
  7. Hi guys, I've been tasked with trying to create a report that counts number of cores and logical processors. Using the info from here http://www.madanmohan.com/2012/11/get-number-of-cores-and-logical.html, I have added the following to the bottom of the sms_def.mof file after making a backup of it: [ SMS_Report (TRUE), SMS_Group_Name ("Processor_Addtl"), SMS_Class_ID ("CUSTOM|Processor_Addtl|1.0")] class win32_processor : SMS_Class_Template { [sMS_Report (FALSE) ] uint16 AddressWidth; [sMS_Report (FALSE) ] uint16 Architecture; [sMS_Report (FALSE) ] uint16 Availability; [sMS_Report (FALSE) ] string Caption; [sMS_Report (FALSE) ] uint32 ConfigManagerErrorCode; [sMS_Report (FALSE) ] boolean ConfigManagerUserConfig; [sMS_Report (FALSE) ] uint16 CpuStatus; [sMS_Report (FALSE) ] uint32 CurrentClockSpeed; [sMS_Report (FALSE) ] uint16 CurrentVoltage; [sMS_Report (FALSE) ] uint16 DataWidth; [sMS_Report (FALSE) ] string Description; [sMS_Report (TRUE), key ] string DeviceID; [sMS_Report (FALSE) ] boolean ErrorCleared; [sMS_Report (FALSE) ] string ErrorDescription; [sMS_Report (FALSE) ] uint32 ExtClock; [sMS_Report (FALSE) ] uint16 Family; [sMS_Report (FALSE) ] datetime InstallDate; [sMS_Report (FALSE) ] uint32 L2CacheSize; [sMS_Report (FALSE) ] uint32 L2CacheSpeed; [sMS_Report (FALSE) ] uint32 LastErrorCode; [sMS_Report (FALSE) ] uint16 Level; [sMS_Report (FALSE) ] uint16 LoadPercentage; [sMS_Report (FALSE) ] string Manufacturer; [sMS_Report (FALSE) ] uint32 MaxClockSpeed; [sMS_Report (FALSE) ] string Name; [sMS_Report (TRUE) ] uint32 NumberOfCores; [sMS_Report (TRUE) ] uint32 NumberOfLogicalProcessors; [sMS_Report (FALSE) ] string OtherFamilyDescription; [sMS_Report (FALSE) ] string PNPDeviceID; [sMS_Report (FALSE) ] uint16 PowerManagementCapabilities[]; [sMS_Report (FALSE) ] boolean PowerManagementSupported; [sMS_Report (FALSE) ] string ProcessorId; [sMS_Report (FALSE) ] uint16 ProcessorType; [sMS_Report (FALSE) ] uint16 Revision; [sMS_Report (FALSE) ] string Role; [sMS_Report (FALSE) ] string SocketDesignation; [sMS_Report (FALSE) ] string Status; [sMS_Report (FALSE) ] uint16 StatusInfo; [sMS_Report (FALSE) ] string Stepping; [sMS_Report (FALSE) ] string SystemName; [sMS_Report (FALSE) ] string UniqueId; [sMS_Report (FALSE) ] uint16 UpgradeMethod; [sMS_Report (FALSE) ] string Version; [sMS_Report (FALSE) ] uint32 VoltageCaps; }; I did a mofcomp on the sms_def.mof file afterwards. I'm trying to build the report using the report syntax on that link but it clearly doesn't find the Processor_Addtl table. Is there a step I am failing to complete in my ineptness? What other steps do I need to do to have this show in say sql server to test the data? SELECT SYS.Netbios_Name0, Processor.Name0, Processor.NormSpeed0 as [CPU Speed], Processor.DeviceID0, ProcAddtl.NumberOfCores0 as [Number of Cores], ProcAddtl.NumberOfLogicalProcessors0 as [Number of Logical Processors] FROM v_R_System SYS JOIN v_GS_PROCESSOR Processor on SYS.ResourceID=Processor.ResourceID left join v_gs_Processor_Addtl0 as ProcAddtl on Processor.ResourceID = ProcAddtl.ResourceID WHERE SYS.Netbios_Name0 LIKE @variable .... where you would have a prompt for "variable" with this as the prompt sql: begin if (@__filterwildcard = '') SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS ORDER By SYS.Netbios_Name0 else SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.Netbios_Name0 like @__filterwildcard ORDER By SYS.Netbios_Name0 end Any help would be great. Thanks!
  8. Hi guys, I've got reboot task sequences setup for all my patch groups to ensure they are ready to be patched and are compliant. We are a retail facility and had a patching freeze over Thanksgiving. I was asked to shut off ALL reboot task sequences during the blackout, not just on the ones that would have patched groups during that freeze. Most of my patch groups throughout the month fall on an early Sunday morning when things are quiet. However, I enabled the pre/post RTS (reboot task sequence) for my dev group at 4:40 PM on Friday for a Sunday morning patching and they ended up grabbing the policy and rebooting around 5:10ish. Needless to say I shut off the other ones. I understand it's completely human error on my part to have done that. But my question is, how can I turn on the rest going forward without them rebooting before their patch window? Keep in mind a lot of my patching windows start around 1am. I have no intention of being up then, so short of being up and manually reenabling them, how can I schedule them say through Task Scheduler? I was wondering if there is a simple way to call a particular task sequence through powershell or something? I want to do it about an hour before their window so that if a machine grabs the policy and reboots, it's close enough to its normal patching window that it's not going to cause an issue. We are running sccm 2007 r2. Thanks.
  9. This may not be the correct forum for this so I do apologize. I'm still a real noob with sccm 2007 r2. We just started using client action tools to try and anticipate/see/fix broken clients. I'm using a text file for a partiular collection and a good deal of the results are kicking out an error Client version ("4.00.6487.2000") is older than expected on "someservername". The parent server shows version 4.00.6487.2000 when I check the properties........so if they match, how can I get this error message? Is there a way to upgrade the clients without going to R3? Is there a better tool to use than client tools? Thanks!
  10. We had an issue a week ago where for whatever reason some of our machines lost their windows activation. What I'd like to do is run a report that shows all the machines where the activation field is blank. Or at least show me the field(s) where the Status Not Available or Poduct ID: Not Available is so I can at least determine what machines at a glance have an issue. I just don't know what table and fields I need to reference in order to build the report. I have noticed the licencestatus0 in VS_GS_SOFTWARE_LICENSING_PRODU table that yeilds a value of 0, 1 and 3. Which is the one that shows registered and not registerd or available?
  11. Like many folks I'm new to sccm 2007. We have an existing dp in a secondary site that has been having disk space issues. We have it configured to download to the E drive, which has about double the package size in free space, but still has issues. I'm assuming it's using the C drive's cache to temporarily hold the data before copying to E. The C drive does NOT have that much availble space. So we're going to add/replace the existing dp with another. My question is how to remove the current one? I went to site systems, new, server and added the new server (in the same physical location/subnet as the existing one). I had taken screenshots of all configured tabs within site settings of the secondary site and mirrored (except for the name of the box) the new dp to match the existing one. So far, under Component Configuration, Management Point Component is the only place where I was able from the drop down specify the new machine vs. the old one. Right now the existing server is configured as a component server, dp, management point, site server and site system. The new one is configured as a component server, dp, management point and site system. I'm probably missing quite a few steps here still. Recommendations? Thanks.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.