Jump to content


Established Members
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by xerxes2985

  1. Thanks Garth for pointing me in the right direction! I now have a properly working report using the following query that gives me everything I need. SELECT v_GS_COMPUTER_SYSTEM.Name0 as "Computer Name" ,IdentifyingNumber0 ,[WarrantyStartDate0] ,[WarrantyEndDate0] ,[WarrantyDuration0] ,v_GS_DELL_ASSETWARRANTYINFORMATION0.Name0 FROM [CM_LIB].[dbo].[v_GS_DELL_ASSETWARRANTYINFORMATION0] join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_DELL_ASSETWARRANTYINFORMATION0.ResourceID
  2. Hi all, I am using the Dell Command Monitor system to gather warranty dates, etc. for all my Dell brand systems. I have a working query, but however the data is gathered, the Dell clients have "extra / duplicate (not exactly)" information that I cannot figure out how to filter out. Additionally, I am trying to take the query and create a report from it so I can export the information. Here's the query: select distinct SMS_G_System_COMPUTER_SYSTEM.Name, SMS_G_System_PC_BIOS.SerialNumber, SMS_G_System_DELL_ASSETWARRANTYINFORMATION_1_0.WarrantyStartDate, SMS_G_System_DELL_ASSETWARRANTYINFORMATION_1_0.WarrantyEndDate, SMS_G_System_DELL_ASSETWARRANTYINFORMATION_1_0.WarrantyDuration, SMS_G_System_DELL_ASSETWARRANTYINFORMATION_1_0.Name from SMS_R_System inner join SMS_G_System_DELL_ASSETWARRANTYINFORMATION_1_0 on SMS_G_System_DELL_ASSETWARRANTYINFORMATION_1_0.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId Here's the results - as you can see from the screenshot, there are multiple entries for the same system. I have worked through this somewhat and can reduce the output to only show those with "Complete Care / Accidental Damage" however, that term wasn't always used by Dell, and some of the computers that are under warranty but don't have the same coverage. This removes the "duplicate" data. where SMS_G_System_DELL_ASSETWARRANTYINFORMATION_1_0.Name = "Complete Care / Accidental Damage" Lastly, I built a report using Report Builder, that has the following query - which works through Query Designer (in report builder), but when I try to run the report, I am met with an error. SELECT Name0 ,[IdentifyingNumber00] ,[Name00] ,[WarrantyStartDate00] ,[WarrantyEndDate00] ,[WarrantyDuration00] FROM [CM_LIB].[dbo].[DELL_ASSETWARRANTYINFORMATION_DATA] join dbo.vSMS_R_System on DELL_ASSETWARRANTYINFORMATION_DATA.MachineID = dbo.vSMS_R_System.ItemKey WHERE Name00 = 'Complete Care / Accidental Damage' Error (I have checked through SQL Management Studio and the user account I ran the query as in the designer has the correct permission): The SELECT permission was denied on the object 'vSMS_R_System', database 'CM_LIB', schema 'dbo'. ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand) ---------------------------- An error has occurred during report processing. (rsProcessingAborted) Any help is appreciated, Jesse
  3. Hi all, What's a quicker way to remove all the discovered users/groups (I accidentally discovered 80,000 users and groups)? Is there a powershell command so that I don't have to delete 1000 users at a time? Thanks
  4. I found a query that works (I added to the queries section in the Monitoring tab). I can get the information I need from there, but I cannot figure out how to take that query and use Report Builder (so I can have a pretty looking report via SSRS) select distinct SMS_R_System.Name, SMS_G_System_PC_BIOS.SerialNumber, SMS_G_System_PC_BIOS.SMBIOSBIOSVersion, SMS_R_System.IPAddresses, SMS_R_System.MACAddresses from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId
  5. Hi all, I need to create a report that will pull some simple information (ComputerName, SerialNumber, BiosVersion and BiosName) from a collection of computers. Manually, I can go to Resource Explorer and expand hardware, and PC BIOS, and get the information, but was wondering if I could extrapolate this easier? Thanks
  6. I have transitioned everything in my site to an HTTPS environment, however, this is the only portion that won't work via HTTPS. I'm not exactly sure what is the reason that having it enabled prevents the updates from appearing.
  7. I have downloaded the most recent software updates for Windows 10 20H2 x64, as can be seen in this image: I went ahead and redistributed the deployment package, to make sure the latest updates added were available. Then, I clicked over to my operating system image. right clicked, and chose Schedule Updates. Those two updates will not show as available as can be seen in this image (additionally, the Windows Malicious Software Remove Tool or update doesn't show as available either): So, to make sure that they aren't already applied, I clicked the update tab on my OS image. Any ideas? Once the image is applied, if I go to check Windows updates, the missing ones download and install. Thanks, Jesse
  8. EDIT: It is amazing how much of an issue can be caused by having this box checked: Once removing the SSL requirement, updates started flowing Good morning/afternoon, I am having issues getting software updates and feature upgrades to appear in Software Center. I have created a Windows 10 Servicing Plan which is deployed to a collection of computers and the "user experience" is set to show everything in Software Center. I have ensured the downloaded Feature Updates (business, 20H2 en-US) are part of the Servicing Plan. I have ensured the client can talk and reach to the WSUS point (via LocationServices.log) Feature Updates aren't showing, nor are software updates. Any help is appreciated.
  9. Checked, everything looks great. I went ahead and removed ADK 2004, and reinstalled ADK 1903, everything is working fine again. I'm going to try removal / re-installation of ADK 2004 again, and see what my results are. Will let you know
  10. Yes. That is what was strange. With the boot image I have been using, I specified a custom background. The boot package ID matched, however the custom background doesn't load. that's what led me to create a new boot image as I thought something was corrupt as it wouldn't load the background.
  11. Yep. Removed the 1903 ADK, removed the PE component, rebooted. Downloaded the 2004 ADK, and the corresponding PE component from the MS docs page. installed adk, then PE, rebooted. rebuilt boot images. I even went as far as creating a new boot image, and using that and enabling it for PXE distribution, thinking that my boot image might be to blame. Ensured also that i have the correct network drivers in the boot image. still results in the same issue.
  12. unfortunately, no. Once the background shows, no keystrokes work. F8 should bring up command prompt, but it does nothing. The only thing I can see before pressing F8 is the background image (MS Endpoint Configuration Manager default background), then a flash (like a window appears), then the computer restarts.
  13. Here is an excerpt from SMSPXE on the last boot I did. It doesn't appear to have any issues. ============> Received from client: SMSPXE 6/29/2020 2:12:56 PM 6544 (0x1990) Operation: BootRequest (1) Addr type: 1 Addr Len: 6 Hop Count: 0 ID: 0001E240 Sec Since Boot: 65535 Client IP: HIDDEN Your IP: Server IP: HIDDEN Relay Agent IP: Addr: 2c:ea:7f:24:6a:49: Magic Cookie: 63538263 Options: Type=93 Client Arch: EFI BC Type=97 UUID: 0044454c4c310010578058b3c04f4e5732 Type=53 Msg Type: 3=Request Type=60 ClassId: PXEClient Type=55 Param Request List: 3c8081828384858687 Type=250 0c01010d020800010200070e0101050400000015ff SMSPXE 6/29/2020 2:12:56 PM 6544 (0x1990) Looking for bootImage LIB00298 SMSPXE 6/29/2020 2:12:56 PM 5488 (0x1570) Prioritizing local MP https://HIDDEN. SMSPXE 6/29/2020 2:12:56 PM 5488 (0x1570) SSL, using authenticator in request. SMSPXE 6/29/2020 2:12:56 PM 5488 (0x1570) In SSL, but with no client cert. SMSPXE 6/29/2020 2:12:56 PM 5488 (0x1570) SSL, using authenticator in request. SMSPXE 6/29/2020 2:12:57 PM 5488 (0x1570) In SSL, but with no client cert. SMSPXE 6/29/2020 2:12:57 PM 5488 (0x1570) ============> REQUEST Reply to client ([HIDDEN:68]) Len:447 SMSPXE 6/29/2020 2:12:58 PM 5488 (0x1570) Operation: BootReply (2) Addr type: 1 Addr Len: 6 Hop Count: 0 ID: 0001E240 Sec Since Boot: 65535 Client IP: HIDDEN Your IP: Server IP: HIDDEN Relay Agent IP: Addr: 2c:ea:7f:24:6a:49: BootFile: smsboot\x64\bootmgfw.efi Magic Cookie: 63538263 Options: Type=53 Msg Type: 5=Ask Type=54 Svr id: HIDDEN Type=97 UUID: 0044454c4c310010578058b3c04f4e5732 Type=60 ClassId: PXEClient Type=243 01515c534d5354656d705c323032302e30362e32392e31342e31322e35342e303030332e7b38304333394438432d433434332d343536462d383631442d3343413335414341314333347d2e626f6f742e766172 Type=252 5c534d5354656d705c323032302e30362e32392e31342e31322e35322e30372e7b38304333394438432d433434332d343536462d383631442d3343413335414341314333347d2e626f6f742e62636400 SMSPXE 6/29/2020 2:12:58 PM 5488 (0x1570) <============ REQUEST Reply (end) SMSPXE 6/29/2020 2:12:58 PM 5488 (0x1570)
  14. Hey all, Since upgrading to CM 2002, I have done the following: Upgrade ADK to 2004, rebuild boot images. Now, when I PXE boot, it loads the WIM, loads up the WinPE environment background - then poof, it restarts (I never get prompted with the password entry to start my OSD). I cannot press F8 to have the command prompt appear (I still have that enabled), therefore I cannot get to any log files to diagnose. I am attempting to deploy Windows 10 1903. Any suggestions?
  15. Good afternoon, Is there a built-in Alert or Report (or one that can be made simply enough) to send an email (or notify in the console) that the Distribution Point certificate is expiring within 30 days? Is this possible? Thanks! Jesse
  16. FYI - If you're having UEFI and PXE boot issues since upgrading to CM 2002, a patch was released today. Here's the details. https://support.microsoft.com/help/4567007 V/r Jesse
  17. Hello all, I've successfully gotten 3rd party software updates working with ADR's, however, I was wondering if there way to remove Adobe Acrobat / Reader 3rd party updates that I no longer need published? If there is a way great, if not is there a way to not have to continually adjust my ADR as new versions of software come out? Example: My ADR for Flash and Acrobat, I'm using title filters to only include the latest version.
  18. So, I ran into an issue running that reporting services configuration manager, that it couldn't find SSRS. Ended up having to remove the SSRS role and reinstall it from from the SQL Server installation center. Reporting is fixed now. Thanks for pointing me in the right direction!
  19. I fixed the redirect issue IIS was set to redirect automatically to the App catalog. SSRS is configured and working, reports work from the console. Can go to /ReportServer and that works. But I can’t get to the web interface for /Reports
  20. @anyweb Niall, Thanks, silly me. I didn't install the ASP.net package. I can now get to SelfService. There's only two issues I have left one - This popped up in yellow text during the script that installed the websites. "WARNING: Unable to determine web service uri to Audit Report. This can be corrected in the web.config for the HelpDesk website." If I try to access http://servername.domain/HelpDesk it immediately redirects to http://servername.domain/CMApplicationCatalog/# If I try https://servername.domain/HelpDesk/# it works fine. Any suggestions?
  21. I'm watching your video now. Hopefully, I'll be able to resolve the SelfService portal.
  22. @anyweb I came across this website, when I found the solution that worked for me. It may have just been a one-off oddity with my setup. https://rcmtech.wordpress.com/2016/10/21/fix-powershell-winrm-remote-connection-errors/
  23. Resolved getting to this website by adding /# at the end of the address. Administration and monitoring website: https://webserver.contoso.com/HelpDesk
  • Create New...