Where do I find my SCCM data?

[bongbaui]

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

[GarthMJ]

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

[bongbaui]

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.

[Jorgen Nilsson]

Hi,

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

 

Regards,
Jörgen

[bongbaui]

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

[GarthMJ]

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.

[bongbaui]

I can now see all the tables and views after getting the access rights changed, thanks to all of you=)!!