Jump to content


  • 0
maravig

All Systems Report produces only one machine!

Question

Hello,

I created a custom report with a collection prompt (SCCM 2012 r2) as seen here:

select distinct v_R_System.Netbios_Name0, v_R_System.User_Name0, v_GS_SoftwareFile.FileName, v_GS_SoftwareFile.FileVersion 
from v_R_System 
join v_GS_SoftwareFile on v_GS_SoftwareFile.ResourceID = v_R_System.ResourceId 
join v_FullCollectionMembership fcm on fcm.resourceid=v_r_system.resourceid
WHERE fcm.Collectionid= @ColID
and FileName = 'iexplore.exe'
order by Netbios_Name0

Everything works, except I only get 1 machine as output! I originally didn't have a collection ID prompt, but it didn't make any difference. I did have to rebuild SCCM 3 weeks ago without the aid of any backup (long story). I turned on software inventory, turned on just about everything (especially SMS_Softwareinstalled, etc), used Right Click Tools, ran hardware and software inventory and still zip. Am I missing anything blatantly obvious?

 

Thanks,

Jeff

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

This is going to happen with one of three reasons,

 

  • Software Inventory is not enabled (and IMO it should never be in the first place)
  • After your site restore you didn’t fix up clients
  • You site restore didn’t work. I’m not sure how you restored a site without a back up!

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.



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