Jump to content


  • 0
bongbaui

Where do I find my SCCM data?

Question

Hi there.

I am new in SCCM.

We have SCCM 2012, and so far 237 clients installed (see attached).

I've looked into several built in Reports but can't find one that matches what we need.

So I thought of creating a custom report.

But when I looked at the database with SQL Server Management Studio, I saw only one table there: dbo.SMSData, and 2 views (see attached).

The table has only one record, and the views retrieve nothing.

 

Where does SCCM get all those data it is showing on the screen and reports?

 

 

 

WhereAreMyData.doc

Share this post


Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0

Thanks Jorgen, will try that first (SELECT permission on the database).

 

The SCCM installation job was outsourced and none of us here in IT knew the sa password of the SQL server.

We are using the Windows server admin account and we thought it would have "admin" rights in SQL server, too, but apparently, its not.

Our manager should soon get the sa password from the guy who set these servers up.

 

Regards,

Bong

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.