Jump to content


bongbaui

Where do I find my SCCM data?

Recommended Posts

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


Check you premission within SQL. It doesn't look like you have full rights to the db.

  • Like 1

Share this post


Link to post
Share on other sites

Thanks Garth.

 

I only have CONNECT SQL and VIEW ANY DATABASE permissions on the server,

and CONNECT permission on CM_[site] database.

 

Will work into getting full rights and update you after.

Share this post


Link to post
Share on other sites

Hi,

You should be fine with "Data reader" permissions, probably easier to get..

 

Regards,
Jörgen

Share this post


Link to post
Share on other sites

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

Keep in mind that even if you don't get the SA password you might still be able to grant yourself SA access but ONLY if you have console access the server/ VM.

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
Reply to this topic...

×   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...