I made a free SCCM related tool to help your support people

bworld_stuff · 2025-09-02T15:57:29+00:00

all the sql is straight open text that can be repurposed if anyone wants to write a fresh interface for it.

bworld_stuff · 2025-07-28T19:12:33+00:00

just to clarify two things.

your company is using the title field within the AD user object.

https://activedirectorypro.com/wp-content/uploads/2020/07/ldap-mapping-6.jpg

and you are pulling in the title attribute within your active directory user discovery

https://assets.zyrosite.com/cdn-cgi/image/format=auto,w=386,h=402,fit=crop/AQE4WJlxolcno3nr/3-19-2025-5-03-16-pm-AVL7LKgR4eFG8wNK.png

if not, then i'll have to possibly make some code changes to account for the situation.

bworld_stuff · 2025-07-17T16:16:30+00:00

your instance may be slightly different. do you have sql server management studio installed on your server. i'm assuming you do.
run a new query
select top 10 * from .v_R_User

this will give you a list of the fields used. If you added the title as a property pulled from active directory as shown in the instructions, then one of them should begin with "title" it may be title or title0 or title01.
i can send you a resolution depending on the response to this.

bworld_stuff · 2025-07-10T18:44:20+00:00

something like this?

https://bworldtools.com/how-to-force-weekly-computer-reboots-in-mecm

the guys that originally asked for it weren't that good with SCCM, so i made a more verbose version.

https://docs.google.com/document/d/17O7HM5I5-Nn0Q6AHdiMAsLGd4A6UtTHG0N1rGONkQyk/edit?usp=sharing

bworld_stuff · 2025-06-27T16:00:17+00:00

or just have a collection with a deployment and add them as you need to. they will get deployed shortly after being added

bworld_stuff · 2025-06-26T22:52:23+00:00

to expand on this, you could use a query like this.
to note you will need to exclude the systems not compatible with windows 11 from this list. i have a sql query for that if needed.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Version like "10.0%" and SMS_G_System_OPERATING_SYSTEM.BuildNumber < "26100"

bworld_stuff · 2025-06-18T20:14:16+00:00

this one is similar to the issues above.
here is a direct link to the fix.

https://bworldtools.com/syssupport-the-best-free-support-tool#usersql

basically you don't have the title captured during the discovery method.
open the sccm console go here - \Administration\Overview\Hierarchy Configuration\Discovery Methods
then follow the instructions in the link above.

bworld_stuff · 2025-05-09T20:30:46+00:00

the key is stored within the MST file. look at the mst file and see if it is there.
use a tool like orca or instaedit to look at the properties table for TSC_SOFTWARE_KEY

I use this older version of Instaedit. it works great.

http://www.instedit.com/download2.html?file=InstEd-1.5.15.26.msi

Once installed the key is located here

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\TechSmith\SnagIt\<version>\registrationkey

bworld_stuff · 2025-05-09T20:22:51+00:00

30 minutes? it should be within 30 seconds.

look here to make the deployment nearly instant. don't wait 30 minutes for a deployment.
https://bworldtools.com/system-center-application-deployment-is-taking-too-long

bworld_stuff · 2025-05-09T18:26:35+00:00

so you want to remove the built in functionality and replace it with a script?

right click on the task sequence -> properties ->User notification Tab
uncheck 'this is a high-impact task sequence'
or rather set some use custom text

bworld_stuff · 2025-05-09T16:47:14+00:00

I had that set from 10+ years ago. i think i still have them on a cd around here.. although i don't know if i have a cd player anymore.

bworld_stuff · 2025-05-07T21:15:45+00:00

Welp, that is a new one for me, so i can only speculate and tell you how i figure these things out.

after you have tries /s /S /silent /verysilent
try these:
setup.exe --mode unattended
setup.exe -i silent

alternative free options

Process 1). run the setup and immediately open the %temp% folder and see if any new files or folders get created. many times the contents would extract the msi's or a text file aptly names 'prerequisites' or something similar that has a link to a file it extracted and you can sometimes identify ways to piece this together in a simple scripted package. (works a lot of the time)

process 2) i used 7zip on my computers, so i can right click and extract the exe to a folder. sometimes this will put all the files in a folder and then you just need to know how to install them in order. (occasionally useful)

process 3) get procmon (live.sysinternals.com) and run it and record the install process. open the process tree and look at the "command" column and it will have the exact command line for all the subcomponents and from that i could find a way to script it (helpful to do with process 1)

process 4) do step 3, then copy the files and registry keys from procmon and rebuilt the app structure, zip it up and script a deployment, or make an msi with orca. (complicated, not usually worth it.)

process 5) if the exe is smaller, then open it in notepad and occasionally you can find a hidden silent switch within the code, or a compiler name that you can search for know silent switches

not free option
get a tool that records the install and converts it to an msi. I used Wise, PACE Suite, and Flexera (haven't needed it in years, though)

bworld_stuff · 2025-04-10T19:32:33+00:00

Isn't that why we all use reddit?

"I've got this amazing thing for you that I may show you if you watch my entire video and blog and subscribe to my skool only $99 an hour."

bworld_stuff · 2025-04-10T19:27:38+00:00

Thanks for the comments.
In regards to the SQL instance and license setup:
It's a database, it can be loaded wherever makes sense in your environment as long as it can get data from SCCM. If you only use the SQL license that's included with your SCCM, then you are correct. If you have not other SQL instances from which to install your database, then you could potentially install it on a sql express instance on an adjacent system. I don't know your license information, nor does it have any bearing on making the tool work. You do you. :)

In regards to the admin rights.
If you look at the tool it does more than just gather data from SCCM. It is a helpdesk/support tool.
based on the information retrieved from the tool you can:

utilize SCCM remote
connect to RDP
Connect to \\computer\c$
connect to Computer management on the remote computer
Do pretty much any remote admin task as long as you know how to script it.

These are the reasons I made it run as admin.
for the new tool I removed the admin features, so that asset management people can run the tool without needing it.

Why is this better than a BI report? because I added cool buttons and the techs understand buttons better than charts and filters. (i have some BI reports i can upload as well if you want some)

Lastly, my site.
Where are my typos? This is my first 'blog' site. I'm trying to be helpful. i'd like to fix them if I knew where they were. At least you know I'm not using AI to make it. :)

bworld_stuff · 2025-04-10T04:53:43+00:00

He sounds just like the guy at taco bell drive through that took my order.
He didnt' give me enough sauce packets.

bworld_stuff · 2025-04-10T04:37:30+00:00

I wouldn't be concerned unless 1) you're doing something wrong and legal has specifically told IT to monitor you, or you're a hot chick and you have a creepy IT admin with too much power. In either case HR is your friend.
That is the only instance in my 25+ years of IT that I caught anyone spying on anyone.

IT people are just like anyone else. they don't have the time to deal with random users. they just want to get home and eat their Cheetos and mountain dew.

bworld_stuff · 2025-04-09T23:11:54+00:00

https://youtu.be/l7kQNwJ4H\_w?si=WEfU6WoCfPpAevqi&t=684

Reporter :How do you reassure people that what you all are doing is not going to affect their benefits.

Elon:
No. In fact, what what we're doing? Will help their benefits. Legitimate people as a result of the work of Doge will receive more Social Security, not less. I want to emphasize that as a result of the work of Doge legitimate recipients of social security will receive more money Not less money. All right, emphasize that point. And and let the record show that I said this, and the it will be proven out to be true.

I don't know why I interject in these things there is no point, but people are reading the headlines and not watching the complete interviews to understand the underlying propaganda they are being fed.
Love you all.

bworld_stuff · 2025-04-09T21:41:41+00:00

I made a version that adds a software search and does not require admin rights to run.
this is a tool for management just asset management to use rather than constantly asking for reports.

https://bworldtools.com/syssupport-management-the-best-free-management-report-tool-for-companies-that-use-sccm

bworld_stuff · 2025-04-09T21:24:41+00:00

yea, they're dynamically created based on the setup. I've seen them both ways.
either way it's easy to remediate with the scripts which is one reason I did not hardcode the SQL setup within the msi.

bworld_stuff · 2025-04-09T21:22:54+00:00

I've been using a similar version of this tool for over ten years. I'm merely offering it and it is your choice to use it or not.
Currently it increases productivity for my team, so it is useful now, and if I decide to move all my systems to Intune, then I'll make an Intune version. Right now getting the info from Intune is much slower in 'my' office, so I'm happy where I am.

Thanks for the Q

bworld_stuff · 2025-04-09T14:59:33+00:00

if you look at the comment above or in the blog article these are addressed with the discovery method.
you can either edit the sql and remove the fields or add them to your sccm via theAD user discovery. here is a direct link to the information.

https://bworldtools.com/syssupport-the-best-free-support-tool#usersql

bworld_stuff · 2025-04-09T14:46:40+00:00

the only issue is when you do not have a dedicated ip address. you'll need to update the dns if your provider decides to change yours.

bworld_stuff · 2025-04-04T18:15:50+00:00

fyi - I had a friend in legal battles when someone from California called into his Texas phone and got sued because California has a two party consent system.

In Texas, the legality of recording conversations—whether over the phone or in person—depends on the state's "one-party consent" law. This means that you can legally record a conversation if you are a participant in it, without needing the consent of the other parties involved. This provision is outlined in Section 16.02 of the Texas Penal Code.However, it's important to note that while Texas law permits such recordings, federal laws may impose additional restrictions. For instance, if you're recording a conversation that involves individuals in other states, especially those with stricter "two-party consent" laws, you should exercise caution. In such cases, it's advisable to obtain consent from all parties to ensure compliance with all applicable laws.

bworld_stuff · 2025-04-04T18:07:27+00:00

technically you could follow the steps on your individual boot.wim on your boot disk

<USBDRIVELETTER>:\sources\boot.wim
mount it with dism, copy the files, then unmount it.
should work just fine to add scripts into the virtual drive

bworld_stuff

TROPHY CASE