Asset Manager
The company struggled with asset management, tracking devices and equipment across multiple sites using outdated spreadsheets. We built an Asset Manager app with Microsoft Intune integration, automatically syncing device data daily from Intune. The platform tracks devices, mobile phones, equipment records and PPM testing schedules, providing real-time compliance visibility, contract management and automated alerts for missing or out-of-sync devices.
Outdated spreadsheets failing to track devices and equipment
Historically, the company relied on Microsoft Intune to track mobile devices and laptops, while maintaining a separate asset register in Excel for managing equipment such as monitors, keyboards, chairs and site equipment. The two systems operated independently with no integration, creating significant inefficiencies and data inconsistencies.
The Excel spreadsheet required manual updates whenever devices were added, removed or reassigned. With hundreds of devices across multiple sites, keeping the spreadsheet current was practically impossible. Information had to be updated in two different locations, leading to duplication of effort and an increased risk of errors. Device compliance status, assigned users and synchronisation health from Intune had to be manually cross-checked. Excel to determine which devices were active or needed attention.
Mobile phone contract management presented additional challenges. The company needed to track which devices had which phone numbers, monitor contract expiry dates and maintain visibility of active devices at any point in time. Without automated tracking, contracts were occasionally overlooked, leading to unnecessary renewals or missed opportunities to renegotiate. Employees also had no centralised system for reporting device issues, repairs or losses, making it difficult to maintain accurate asset records and ensure operational transparency.
-
Manual tracking between Intune and Excel
Device data had to be manually duplicated between Intune and spreadsheets, creating constant inconsistencies and outdated records.
-
No centralised system for mobile contracts
Phone numbers, contract expiry dates and device assignments tracked manually, leading to missed renewals and poor visibility.
-
Lost or stolen devices hard to identify
No automated alerts when devices hadn’t synced for extended periods, making it difficult to detect missing equipment.
-
Site equipment and peripherals untracked
Monitors, chairs, keyboards and site equipment tracked separately with no visibility of who had what or where items were located.
Intune-integrated asset platform with automated daily synchronisation
We designed and built an Asset Manager app integrated with Microsoft Intune via API, eliminating the need for manual spreadsheet updates. The platform automatically syncs device data daily from Intune, tracking laptops, tablets, mobile phones, site equipment and peripherals in one centralised location. Contract management, compliance tracking and automated alerts ensure nothing falls through the cracks.
-
01
Intune Integration — Automated Daily Sync
Power Automate connects to Microsoft Intune via API every night, retrieving all device information including compliance state, assigned users, device models, serial numbers and last sync dates. For mobile devices, the integration also captures phone numbers when supported by the SIM card. All data is automatically updated in Dataverse, ensuring the asset register is always current without manual intervention.
Intune APIPower AutomateDaily SyncAuto Updates -
02
Mobile Contract Management — Phone Numbers & Expiry Tracking
The app tracks mobile phone contracts, linking devices to phone numbers and monitoring contract expiry dates. Managers receive automated alerts when contracts are approaching renewal, providing visibility of how many active devices are in use at any point. This eliminates missed renewals and ensures the company maintains control over mobile device costs and commitments.
Contract TrackingExpiry AlertsPhone NumbersCost Control -
03
Missing Device Detection — Automated Alerts
The system monitors when devices last synced with Intune. If a device hasn’t synced for more than 30 days, managers receive automated notifications to investigate potential missing, lost or stolen equipment. Users can add notes for repairs, tracking and incidents, maintaining a complete history of each device and ensuring accountability across the organisation.
Sync Monitoring30-Day AlertsRepair TrackingNotes & History -
04
Site Equipment & Peripheral Tracking
Beyond Intune-managed devices, the app tracks all site equipment and peripherals including monitors, keyboards, mice, chairs and site-specific tools. Users can see who has what equipment, where items are located and track assignments across sites. Everything is managed in one platform, providing complete visibility of the company’s asset base from laptops to furniture.
Equipment TrackingPeripheral ManagementSite AssetsAssignment Tracking
Ten weeks from discovery to go-live
A structured programme integrating Intune with Power Platform and building a comprehensive asset management system. Delivered through regular sprints with testing across device types and sites.
Real-Time Integration
The Intune integration runs automatically every night, ensuring device data is always current. Compliance states, assigned users, device models and sync status are pulled directly from Intune via API and updated in Dataverse, eliminating manual spreadsheet updates and providing IT teams with a single source of truth for all asset data.
📱Asset Coverage
- •Laptops & tablets (Intune)
- •Mobile phones & contracts
- •Monitors & peripherals
- •Chairs & furniture
- •Site-specific equipment
- •Repair & incident tracking
Complete asset visibility with zero manual updates
Data Accuracy
Device information synced daily from Intune. Asset register always current with no manual spreadsheet updates required.
Automated Sync
Intune integration runs every night, automatically updating compliance states, assigned users and device details across the organisation.
Missing Device Alerts
Automated notifications when devices haven’t synced for 30 days, enabling rapid investigation of lost or stolen equipment.
Contract Management
Mobile phone contracts tracked with expiry alerts, providing visibility of active devices and preventing missed renewals.
Equipment Visibility
All assets tracked in one system — from Intune-managed devices to site equipment, peripherals and furniture.
Spreadsheet Updates
Multiple asset spreadsheets eliminated. Single platform provides real-time visibility with no manual data entry.
Still running inspections on paper?
Book a free 30-minute discovery call. We will map your current inspection process, show you what a digital solution looks like and give you a clear view of what is achievable — with no commitment required.