Try It
Print

Windows Inventory Collection Script

Copy the URL link to this section to share

Many customers have requested the ability to report on things that are either not collected or not accurately collected by Intune. In an effort to fill these gaps in we have implemented a custom solution to collect some of the most commonly requested items. Currently this list includes:

  1. Software installed on Windows 10 devices.
  2. Software installation date.
  3. Monitors (LCD’s) connected to Windows 10 devices.
  4. Disk health.
  5. Last Reboot time.
  6. Additional CPU details.
  7. OS Install date.
  8. Additional RAM details.
  9. Battery health.
  10. Friendly model names for Lenovo computers.
  11. Warranty information for Dell, Lenovo, HP, and Getac computers.
  12. M365 update installation and compliance details.
  13. Windows driver inventory.

This data is collected via PowerShell, sent to a Log Analytics workspace, and then pulled into Power BI. Most customers leverage a Proactive Remediation detection to run the PowerShell script on a defined schedule. In this document we describe how to configure the script and deploy it using a Proactive Remediation however there are many ways that you might run a script on a schedule. 

Prerequisites: 

  1. Appropriate licenses to use remediation scripts in Intune.
  2. Dell requires an API token, which you can request by applying at https://techdirect.dell.com/Portal/APIs.aspx.

  3. Lenovo requires a client token. Unlike Dell, this process is less straightforward—you’ll need to contact your Lenovo account representative to request the token on your behalf.

  4. HP requires both an API key and a secret. Note that the secret expires frequently. During our testing, the HP API was often unreliable; however, their support team was responsive, and it’s encouraging to see HP making the API available to customers again. You can initiate access by contacting your HP representative or by signing up at https://developers.hp.com/.

You can copy the PowerShell script from our GitHub repository. 

github mark
Get the Script
Step

  1. Paste the PowerShell code into your favorite script editor.
  2. On the line starting with $CustomerId = enter your Log Analytics Workspace ID between the quotes. 
  3. On the line starting with $SharedKey = enter your Log Analytics Workspace Primary Key between the quotes. 
  4. Save the script as a .ps1 file. For example CollectInventory.ps1.   
(click to enlarge)
Step

  1. If you plan to collect warranty data set $CollectWarranty = $true.
  2. Warranty data is cached locally on each device so that we do not make a call to the manufacturer API for each device each day. The cache is refreshed every 180 days by default. This is configurable using $WarrantyMaxCacheAgeDays. The cache can be force refreshed using $WarrantyForceRefresh.
warranty enable
(click to enlarge)
Step

  1. If applicable enter the Dell Client ID and Client Secret values. When you retrieve this info from TechDirect it will be in a format similar to xxxxxxxxxx (yyyyyyyyy). The part before the opening parenthesis is the Client ID, the part inside the parenthesis is the Client Secret. (Note: Do not enter the parenthesis themselves in the script)
  2. If applicable enter the Lenovo Client ID provided to you by your Lenovo account rep.
  3. If applicable enter the HP Client ID and Client Secret provided to you by your HP account rep. (Note: HP expires their secrets very frequently so you will have to update these regularly.)
warranty keys
(click to enlarge)
Step

  1. In the Intune console select Devices
  2. Select Scripts and remediations.
script and remediations
(click to enlarge)
Step

  1. Select Remediations.
  2. Select Create.
create remediation
(click to enlarge)
Step

  1. Enter a Name.
  2. Enter a Description.
  3. Select Next.
(click to enlarge)
Step

  1. For the Detection script file, browse to and select the Inventory.ps1 file. 
  2. Select Yes to run script in 64-bit PowerShell.
  3. Select Next.
(click to enlarge)
Step

  1. Optionally add Scope tags.
  2. Select Next.
(click to enlarge)
Step

  1. Select the devices from which you want to collect inventory. 
  2. Adjust the schedule per your requirements. 
  3. Select Next.
(click to enlarge)
Step

 

  1. Confirm all of the settings are correct. 
  2. Select Create.
(click to enlarge)