Analytical Reports - Hardware inventory report
It would be great to be able to generate a report that shows all the computers under a client and show at the same time all the hardware information including operating system, cpu, ram amount, hard drive or ssd on the same page.
It seems like a essential feature for this software to be able to have an inventory of a client
Hi,
We're excited to inform you that the feature you suggested has been implemented and is now available to all plans that include Explore (Creating custom analytical reports) features.
Please use this link to see the most recent comment from us to understand what is available today and what are the possible next steps for you: http://atera.uservoice.com/forums/936306/suggestions/46937614
Thank you for helping us improve Atera!
Best regards,
The Atera Team
-
Anthony Hegedus
commented
Hi Dmitry
Ah I see - I thought this was a pre-prepared report. Is this a new thing, or was this always available then?
I would be interested, in a webinar, yes.
Kind regards
Anthony -
Hi Anthony!
Here’s the quickest way to find and build the hardware report you asked about (text-only, no screenshots).
- Go to Reports in the main menu.
- In the left pane, under Analytical Reports, click the + to create a new report.
- Pick the Devices dataset → Build report.
- In the Explore (builder), use Find a field instead of opening folders one by one. Add:
- agent name
- customer name (you can also add this as a filter)
- vendor (brand) and model
- serial number (choose the serial field you prefer if it appears in multiple sections)
- processor (CPU)
- memory (RAM)
- space (disk free/total/used)
- hardware disk drive (use this as a filter to keep only master drives if needed)Set Visualization to Table → Run (top right corner).
- Gear icon (top right) → Save → save as a new dashboard.
- My folder = just for you
- Group/Shared folder = visible to colleagues
- Title example: Hardware – High-Level OverviewView dashboard → Add filter → choose Site name or Customer name.
- In Control, select Tag list (enables multi-select for the dropdown) → Update → Save.
To add missing fields later: three dots (top right) → Edit dashboard → edit the tile or click Add to insert a new visualization (New Tile) with additional fields.Notes: agent names in the table are clickable to open the device page. Some behaviors in the analytics UI come from Looker BI and follow its native patterns.
PS: We're in the internal talks to have an in-depth technical webinar on the topic. Would you be interested in joining?
-
Anthony Hegedus
commented
Where is this report?
-
Hi everyone,
I've studied the thread and I wanted to share what we currently offer:
In short: Yes, you can build a single-page table of all computers under a client with OS, CPU, RAM, disk/SSD and much more today using Reports → Analytical Reports → Devices. Export to CSV/PDF/JSON/MD/XLSX and some other formats, save, and schedule delivery.Hardware inventory per client - available today via Analytical Reports (Devices dataset)
Plan availability:
- MSP: available to Power and Superpower plans.
- IT Departments: available to Master and Enterprise plans.
- Not on these plans? Ask your CSM/CX for a 2-week trial of Analytical Reports so we can show you the value. If you don't know who to contact, please reach out to our Support Team.If there’s broad interest, we’re happy to host an in-depth technical webinar or series on building hardware/software inventory reports and scheduling them.
What fields are available (non-exhaustive, grouped as there are almost 700 fields available in Devices dataset alone):
- OS & Software: OS, OS build, Windows serial number, Office version, TLS version, public IP address, machine name, environment number.
- CPU & Memory: Processor, clock speed, core count, memory (RAM).
- Disk / Storage: Disk total/free/used, % free/% used, available disk capacity tiers, system drive; per-drive: hard disk ID/serial, model, name, media type (HDD/SSD), interface/bus type, partitions, location, index, health status, operation status, firmware version, type, device identifier, device note.
- Security: BitLocker status, BitLocker status name.
- Battery (laptops): Battery health, cycle count, design capacity, full-charge capacity, battery name.
- BIOS & Board: BIOS manufacturer, release date, version, last update date, model of motherboard, vendor, model of laptop.
- Network: Hardware MAC address, primary MAC (Y/N), network adapters, adapter name, item ID.
- Graphics/Audio: Video card, sound.On top of that, Custom fields (Power/ SuperPower/ Master/ Enterprise) and Script-based custom fields (SuperPower and Enterprise plans) are also available to be added to these reports.
Please let us know if you want to know more, we will be happy to elaborate on this topic and beyond.
++
Dima L
Technical Product Marketing Manager
Atera -
Brendan Richman
commented
Isn’t all of this on the Auditor report?
-
Gurmukh Jagdev
commented
At the very least have the device name and contact info of the person it's assigned to, should be easy for Atera to implement
-
Jens-Peter Vraa Jensen
commented
Add warranty lookup based on serial number
-
Patrick PARAIS
commented
Bonjour
Ne pas oublier aussi d'ajouter le model de Disque.Merci d'avance
-
n toussaint
commented
et il serait sympa de pouvoir sélectionner les éléments que l'on veut afficher dont les champs personnalisé pour un Numéro d'inventaire par exemple.
-
Shawn Rose
commented
I agree it would be nice to have historical data, but I would also want to have a force refresh option: For some of the data, once it's pulled Atera never seems to check it again. Office versions in particular: I've seen cases where it still shows Office 2016 despite it having long since been upgraded to 365.
At least for the data that Atera already pulls and has available, this is pretty easy with the API. Powershell script (Edited from the one I use which also does a few things like map location via public IP to a site from our Meraki infrastructure, which are stripped). No idea how much of it will stay on this comment, though. (Apparently, everything but the tabs and some random characters getting HTML escaped: Oh well)
$AteraHeaders = @{"X-Api-Key" = "Your API Key"}
$AteraDevices = $null
$Run = $true
$Page = 1
$Count = 0
while($Run){
$Items = Invoke-RestMethod -Headers $AteraHeaders -Uri "https://app.atera.com/api/v3/agents?itemsInPage=50&page=$Page"$Page++
if(-not $AteraDevices){
$AteraDevices = New-Object PSCustomObject[] $Items.totalItemCount # Uses lass ram since it isn't going to be recreating the array all the time to add items
}
foreach($Device in $Items.items){
$AteraDevices[$Count] = $Device
$Count++
}
"$Count / $($Items.totalItemCount)"
if($Count -eq $Items.totalItemCount){
$Run = $false
}
}$AgentInfo = foreach($Agent in $AteraDevices){
$DiskSize = $null
$DiskFree = $null
$DiskPercentage = $nullforeach($disk in $Agent.HardwareDisks){
if($disk.Drive -eq "C:"){
$DiskSize = [Math]::Round($disk.Total/1024)
$DiskFree = [Math]::Round($disk.Free/1024)
$DiskPercentage = [Math]::Round(($disk.Free / $disk.Total)*100)
}
}
$Uptime = $null
if($Agent.LastRebootTime){
$Uptime = ([DateTime]::Now - [DateTime]::Parse($Agent.LastRebootTime)).Days
}
[PSCustomObject]@{
ID = $Agent.AgentID
Online = $Agent.Online
Name = $Agent.SystemName
User = $Agent.LastLoginUser
Domain = $Agent.DomainName
'Reported IP' = $Agent.ReportedFromIP
'Internal IP' = $Agent.IpAddresses -join "; "
'Uptime' = $Uptime
OS = $Agent.OS
'OS Build' = $Agent.OSBuild
Office = $Agent.Office
'Office Build' = $Agent.OfficeFullVersion
Vendor = $Agent.Vendor
Model = $Agent.VendorBrandModel
CPU = $Agent.Processor
RAM = "$([Math]::Round($Agent.Memory/1024)) GB"
'Disk Free' = $DiskFree
'Disk Size' = $DiskSize
'Disk Usage' = $DiskPercentage
Serial = $Agent.VendorSerialNumber
}
}$AgentInfo | Export-Excel -NoNumberConversion Model,Serial -Show
-
Paul Johnson
commented
That report can be written in PowerShell and output to Excel as a csv. It would need to be run from inside the domain on something with Office installed.
-
Jeff Smith
commented
I'm pretty sure this didn't work in the past as I had a similar complaint. However, I believe it's fixed now. If you go into Advanced reports, apply a filter, refresh, and select Windows PC tile, you will get a downloadable report with just that customer's Data. It includes good basic H/W info:
Machine Name OS Environment Name Bios Manufacturer Bios Release Date Bios Version Memory Motherboard Sound System Drive Vendor Domain Name Domain Group Last Logged User Last Seen Date Model Serial Number Last Reboot Time Video Card OS Processor Clock Processor Cores Count
Obviously, it's missing some fields that would be useful such as: IP Address, MAC, OS ver&build, AV type&status, disk capacity, disk model, disk free space, non-boot disk info, bitlocker status, and I'm sure more. All of this data is available from the Device info screen for an individual device and it would be nice to have a comprehensive report, but at least a basic amount of h/w data is available from the Advanced Report function.
-
Laurent Morel
commented
A better hardware dedicated report would be nice.