bongbaui

Thanks Jorgen. Indeed I now have those info in SCCM after I've asked the users to lock their computer and stay logged on overnight. Regards, Nestor

Greetings everyone ! With reference to attached: NoLastLogonUserNameAndDomain.doc I found a few SCCM clients having this issue: Last Logon User Domain = <blank> Last Logon User Name = <blank> We're using SCCM 2012. AD Forest, AD System, AD User, Heartbeat, and Network discovery are enabled, scheduled once a week, except for Network which is once a month. AD System and AD User delta discoveries were also enabled with interval of 5 minutes. Tried searching for solution in the internet but wasn't able to find one. I'm new in SCCM, and would greatly appreciate replies from you guys to get this fixed. Thanks, Bong

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

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

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.

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