Need SQL query to create the report for linux/unix servers with following fields.Tried in report writer and web-console,but not able to pull the report.
| Computer Name |
| Computer Model |
| Current Operating System |
| Service Pack Level/Version |
| Active Network Adapter |
| IP Address |
| MAC Address |
| DNS Server |
| Subnet Mask |
| WINS Server |
| Registered User Name |
| Domain/Workgroup |
| Days Since Domain Account Update |
| Number of Processors |
| Number of Cores |
| Logical Processor Count |
| CPU |
| System Memory (MB) |
| Video Card |
| Video Card Memory (MB) |
| Sound Card |
| Disk Drive |
| FreeSpace(GB) |
| Disk Drive Size (GB) |
| Optical Drive |
| BIOS |
| BIOS Serial Number |
| BIOS Manufacturer |
| BIOS Release Date |
| Machine Type |
