SCCM 2012 sql query

Bruce Meyer 20 Reputation points
2024-11-18T13:12:50.9533333+00:00

Need assistance to pull a report that can provide the asset name, domain, username, product, warranty, cpu, total size HDD, free disk space, OS,

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,944 questions
Microsoft Configuration Manager
{count} votes

1 answer

Sort by: Most helpful
  1. Sherry Kissinger 5,171 Reputation points
    2024-11-18T13:27:48.3066667+00:00

    Name, domain, CPU, Total Size HDD, Free disk space, OS == all that, sure. Look at existing reports on your reporting site.

    username: sure... but there may be caveats with that. last logged in user vs. "most frequent user" can be different things.

    Product: a specific product or 'all things installed' (which, you will NOT want to do, that can be thousands of pages of info).

    Warranty: Unless you already have something that pulls in warranty info, this is not something recorded on the device, therefore it cannot be reported to the CM database. Do you have a 3rd party thing populating that information on the device? If not, do you have an Asset Management system which holds that information? You may need to get someone who manages THAT system to do a cross-database report.

    You didn't ask this, but there are for-pay companies which offer reports, including warranty information reports. If that is of interest to you, reply and I can post a couple of those companies (or just web search)

    2 people found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.