Dear Support,
Please help me out in generating this report to reconcile the assets with our current Inventory.
which includes
Employee ID
User,
Department,
Last Logged in User
Site
Location
Region
Asset State
CI Name
Model
Product Name
Part No.
Purchase Order No.
Cost (Rs)
Serial number
Service Tag
Asset Tag
Org Serial Number
Barcode
OS
Disk space
Total Memory
IP Address
Mac Address
Processor Name
Current Asset Value (Rs)
Acquisition Date
Expiry Date
Warranty Expiry Date
Database: SQL Server