GarthMJ
-
Posts
1949 -
Joined
-
Last visited
-
Days Won
93
Posts posted by GarthMJ
-
-
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?
-
1 hour ago, Kiran chandra B said:
We have 3 primary servers in different regions, so need CAS server , on checking doc to to resolve your TLS problem, I see below error when i open the URL in web browser, should i turn on TLS1.0, 1.1 ,1.2 on CAS server and what is impact of doing Turning on TLS 1.0,1.1,1.2 on SCCM servers, network and other things
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.
-
8 hours ago, Kiran chandra B said:
can we do this change only on CAS server or on all primary servers also
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?
-
2 hours ago, Kiran chandra B said:
Thanks for above info, Also wanted to check if we can estimate the increase to the DB? what is the size now and how much space on the drives where the DB file is?
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.
-
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
-
50 minutes ago, MES805 said:
Hi all,
With respect to the one-liner "Use the built-in reports.": There are like 250 canned reports in SCCM, and I have yet to find a good summary of what-all they do and which are superior for what purposes. I regularly use the "Add Remove Software" to see historically what an individual device has installed, but like the original request, I'm looking for a better report to export in CSV format what machines have what software installed into them on a collection-wide basis.
Any opinions on what reports or pre-fab queries might offer this search?
Thanks!
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?
-
What is unclear with the error messages? You have exceed the size limit and computer doesn't existing within the db. On top of that It is NOT recommend to enable SW inv. there are just far too many problems and it is NOT reliable. https://www.enhansoft.com/sccm-software-inventory/
-
Being able to ping or not, does not show a problem per se. For example from the site server when you ping the computer is it the right IP address? Can you connect to the Admin$ of the computer AS the site server itself (aka NOT you).
-
The error is clear the device is not on the network or it get access denied to it. So what troubleshooting have you done?
-
exit code 2 = The system cannot find the file specified.
-
it is a SQL query.
-
Any WS that is approved, is approved for the life of the ResourceID. However if the ResourceId changes for any reason, then you will need to re-approve it.
So it sound like your WG computers are duplicated and old computers are purged out and a new resouceid is created for the computer.
-
What exactly isn't working for you?
Also remember that the BIOS version is a string not a number too.
-
Well, there you go, you will need to create your own powershell/VBS script to do the detection. And move the data to an area that CM can inventory. Once you do that you can have CM inventory the data. This might not be a simple task as it will depend on if the users are Admin on their computer or not.
-
ok, I will bite, why isn't this doable for you? Are you trying to say this doesn't work for you because of the cloud lic?
-
This first thing you are going to what to do is understand where the data that you want existing within CM.
These two links will help you with that.
https://www.informit.com/store/system-center-configuration-manager-reporting-unleashed-9780134466811
.
-
1
-
SCCM query
in Configuration Manager 2012
Posted
What is wrong with the built-in reports for this?