Finding table equivalent in SCCM 2012

[MKastSCCM]

Hello -
I'm a new(er) SCCM admin and working on porting over custom reports from our SCCM 2007 environment into the new SCCM 2012. Got most of them over, except a few where the tables used no longer exist as they previously did.

 

The table equivalents that I need are:

v_GS_SMS_Installed_Applica0

v_GS_VNC_Remote_Sessions0

v_GS_Windows_7_Logon0

 

Also, if anyone knows of a good resource (other than this form) for learning more about reporting, I'm all ears!

 

Melissa

[GarthMJ]

It looks like all of those are custom classes, So this isn't going to be easy..

Currently how is the data collected for these views?

[MKastSCCM]

1) Thanks for the reply.

2) Honestly, I don't know. (Again, new to this...still learning something new every day.) Any pointers on how to find/figure that out?

 

 

A lot of these reports were probably ported over multiple versions of SMS/SCCM by people who are no longer with the company.

[GarthMJ]

I wouldn't bother porting them over unless I know for use
that they are being used. Then if someone know that they are being use they should
also be able to answer the question on how the data is collected too.

[MKastSCCM]

Well, I found out that that data SHOULD be collected via our MIF files, but the tables are not being created. We do have hardware inventory set to collect the files, but tables aren't being created.

[GarthMJ]

CM12 does NOT process Custom MIF files without you importing them first. Have you imported the MIF files yet?

BTW, I NEVER recommend using MIF files anymore, there are far more efficient ways to capture the data. Since you are moving to CM12, I would recommend that you look at converting all your MIF files to sms_def.mof edits or DCMs.