GarthMJ

https://docs.microsoft.com/en-us/internet-explorer/ie11-deploy-guide/set-the-default-browser-using-group-policy

There is no option to force people to change their pin every 30 day, you will need to write a script to do this with a custom interface. Personally I would NOT be doing it that often.

What have you tried? what isn't working for you?

Yes, there are at least 4 bitlocker repot within CM. No the report should be there BEFORE turned on bitlocker. You will need to review the CM reporting point logs to see what the deal is.

There should be some powershell commands to do this. aka edit the WMI data.

So are you only using IP Ranges? Have you reviewed the logs as to where the content is pulled from and to ensure that the content is distributed to the DP?

What exactly are you using for Boundaries? I hope it is IP Ranges ONLY.

What exactly do you mean by "doesn't talk back to the site server"? Is HW inv working? IS Mach policy working? is Client installed? How was the client installed? What version of MECM are you taking about? are you HTTPS or eHTTP?

There are far too many reasons to list here. What Troubleshooting have you done? Have you review the logs?

everything that you need is listed within the online docs. SQL Server views - Configuration Manager | Microsoft Docs

What is wrong with the built-in reports for this?

What isn't working with this query? aka why are you looking for help?

For urgent requests, you should contact Microsoft paid support. Forums are for admin to help other admins.

Why are you not using the Robo copy command as the command line, aka why wrap it is a vbs?

Nothing, as that is the default to have TLS 1.2 enabled. But keep in mind that since you have a CAS and therefore over 150, 000 computers, you should be opening a support ticket with MS directly. As their might be a reason why TLS 1.2 was turned off.

As I says in the blog, you must do this on your primary and CAS servers.

CM itself doesn't use "my docs" or "desktop", Why do you think folder redirection is a problem/conflict for CM?

I user 15-20mb per client + 2gb for the db itself. (#of clients * 20mb) + 2048 MB for db size. But honestly, the db size is not the issue, having the correct data is the issue and db grow within reason is more important.

It is the same affect BUT if you are going to change it to 10 MB why not go to the max that is can be? What problem will setting it to 10mb solve that 50 mb will not solve? BTW, I'm finding that the avg full MIF is ~ 15mb these days, with AI data so....

Well you DB size increase, yes it will but you will likely never notice it. And or you will not care as having the inventory is more important that the db size.

On you CAS Nothing. On your Primary site, it will allow the HW inventory to be added to the db. Also keep in mind that this will REDUCE (yes reduce) network, CPU and IOPS on your clients and MP, site server as it will Stop the resync looping. Go strait to 50 MB, don't bother with anything smaller. Change the Maximum File Size of a MIF - Recast Software

First off it is NOT support to query the tables directly for you report. Only use the supported SQL views listed on the docs page too. Hardware inventory views - Configuration Manager | Microsoft Docs This is why you are see a permissions issue. Secondly the dups are to be expected, as the dell service give you all of the row that you see within the web page. I wrote a blog on why you need normalized details. You Need Normalized Warranty Results - Recast Software

There are a few Q there: Here is a list of all of the report and what they display. List of reports - Configuration Manager | Microsoft Docs Reports will show current detail, as of the last HW inventory cycle (not historical), and I hope HW inv. is set to daily too Remember that all report can be exported to a CSV or PDF or Word or Excel. Just use the save option on the report sub menu. Are their other prefab reports out there, Yes. some are free, some are not or you can create your own just be carful to do it right. Keep in mind that I do work for a company that does create prefab reports and as such I can't point you to others out there.

To convert this to SQL. I would prefect the query within SQL server Management studio first, before bring it over to report builder. The views that you need are: SMS_R_System = v_r_system SMS_G_System_PC_BIOS = v_GS_PC_BIOS

What do you have for a query already? what isn't working for you?