GarthMJ

You would use this for your prompt queries. For SSRS, you would only need the "else" query with a few quick mods. I see from your screenshot that you have to manually type each item. personally, I would extend this to: Prompt for manufacturer name Prompt for model name (use cascading prompt) Prompt for BIOS version (use cascading prompts)

Just to be clear there is no such version as CM12 (1710) since you called out 1710, you must have CMCB 1710. How exactly are you creating this report? What do your prompts look like?

This was written for CM07. What version of CM are you using?

From a performance stand point it makes no sense to share a SQL cluster with a CAS and primary site(s).

Having all the cas and primary sites all using the same SQL servers is clearly not best practice. why splits the primaries with 44k and 30k?

I hate to say it but have one SQL server for you cas and three primary site doesn't make any sense.the whole point of a cas and primary is for work load. if you are combining them into one SQL server them you are suggesting that you don't have a lot of load.

That query will only give you last logon user. plus there is already built in reports with those details, so no need to create another.

Have you looked at the built-in reports?

Your issue is that you are trying to copy to a network share. Since the client doesn't have access to the share this will fail. This blog will help show the issue. https://verbalprocessor.com/2007/12/05/running-a-cmd-prompt-as-local-system/

Since Win2003 have been “dead” for over two years, there is a good chance that CMCB 1710 doesn’t support it anymore even un-officially. Therefore your best best is to contact your TAM or CSS to get support on this.

It means that they don't have the CM client installed on them. Install the client on them and thing get updated.

I did answer you in the other forum. Again here are the blog that will help you. http://sccmug.ca/?s=subset

You should contact CSS for support. They can work with you to solve all of your issues.

60 GB for C:\ is a bit small IMO. I use a minimum of 127 GB. 10 GB for the Page is tiny! With 128 Ram I would use a minimum of 350 GB for the Swap file. 4.8 TB is not a lot of space these days. Instead of doing RAID 50, I would be more inclined to do RAID 5 or maybe RAID6. If you are going to stay with RAID 50 then get bigger drivers.

Have you looked at the built in reports for this.

why have a CAS and two primary sites?

Yes, CMCB will inventory what is installed on each computer. But you will not know what Lickey was used to install it. Importing the CVS only allow you to use a report to see over and under numbers, but I have never found it all the useful.

CMCB will not do any of that.

CSS is Microsoft Paid support.

if I remember right sms_fsp is the Fallback status point and if you are getting lots of hit on it then you like have an issue with your environment. Maybe a cert issue. Look FSP reports, check your certs. Re-reading this thread, IMO you have a certificate / PKI issue. PKI is a huge pain in the a.. ; hence why I never recommend it. It might be time to contact CSS directly for support.

You need to open one of the IIS logs and look at what is going on. From there you can tell if MP traffic or Inventory traffic or what is making your logs grow.

This query will only find x86 version of the software. You will need to update the collection to gather x64 version too. https://www.enhansoft.com/blog/combining-two-wql-queries-in-one-collection

it sounds like your site is not healthy. Test you MP is it working correctly? https://www.enhansoft.com/blog/how-to-test-your-mp-to-confirm-if-it-is-healthy if not remove it and add it back again.

What does your collection query look like?

Is it set for a fixed time or a simple time for the Hardware inventory? BTW, I recommend this be set up for daily. https://www.enhansoft.com/blog/configuration-manager-inventory-cycle-recommendations