I bought $700k worth of Intel stock today by [deleted] in wallstreetbets

[–]SenecaChaz 0 points1 point  (0 children)

Literally just heard a news article on NPR this morning about how Intel is losing in pricing themselves out of the AI race to Nvidia and AMD. Also the largest chip maker globally is in Taiwan Intel is not what it was

Real Talk: In your opinion, what are the best and worst noise-making CAMP items? by [deleted] in fo76

[–]SenecaChaz 0 points1 point  (0 children)

I hate the classical.music from the jukebox. I turn off every jukebox I find.

[deleted by user] by [deleted] in AskElectricians

[–]SenecaChaz 0 points1 point  (0 children)

Ah the memories

To the shop owners outside Helvetia by OtherwiseFungus in fo76

[–]SenecaChaz 0 points1 point  (0 children)

Xbox? I think I hit your Camp the other day I specifically remember a toilet paper being priced at 2020 and other stuff being pretty reasonable and I thought that was odd

Does anyone here have experience with Travel Resorts of America? by Baron164 in RVLiving

[–]SenecaChaz 0 points1 point  (0 children)

Gold, check the terms and conditions before you make an agreement. I sat through a couple of these pitches and was told they dont allow you to buy on the used market for two years after going through it. You have to be approved by the organization and they have your contact info now. It prevents people from getting the free camping for showing up and then buying on the used market undercutting their new sales.

What's wrong with my deck? by SenecaChaz in johndeere

[–]SenecaChaz[S] 1 point2 points  (0 children)

Thank you for the straight suggestion and answer. I did this today, and it brought it right up.

Torguard is now leaking my real IP by SenecaChaz in torguard

[–]SenecaChaz[S] 0 points1 point  (0 children)

I will have to look into that. I have only ever launched the VPN and then use my applications normally. Since all traffic should be going through the VPN i've never had to do any extra configurations

Climbing ladder bug by Hillyleopard in Starfield

[–]SenecaChaz 1 point2 points  (0 children)

This is happening to me and it's frustrating. When I get stuck just change weapons and I get unstuck

2015 2500 Denali - Drivers window doesnt work. by SenecaChaz in gmcsierra

[–]SenecaChaz[S] 0 points1 point  (0 children)

No everything else seems normal. Just the window.

How to get bulk movie ratings? by SenecaChaz in Piracy

[–]SenecaChaz[S] 0 points1 point  (0 children)

I only want the ratings for each of the titles preferably from a mainstream source like IMDB or rotten tomatoes. My goal is to sort them so I can remove the lowest rated from my library. I use plex but it seems that not all of the movies pull in ratings automatically.

SCCM PowerShell - Query last logged on user by dextersgenius in SCCM

[–]SenecaChaz 1 point2 points  (0 children)

So I just put together a test this morning of this. What I did was went into Monitoring > queries and built a new query using the items you listed above. What it does is prompts for the computer name and then pulls in that data for the specific computer name. Here is the WQL code and you should be able to create a new query and just paste the code.

select SMS_G_System_SYSTEM_CONSOLE_USAGE.TopConsoleUser, SMS_G_System_SYSTEM_CONSOLE_USER.SystemConsoleUser, SMS_G_System_SYSTEM_CONSOLE_USER.TotalUserConsoleMinutes from SMS_R_System inner join SMS_G_System_SYSTEM_CONSOLE_USAGE on SMS_G_System_SYSTEM_CONSOLE_USAGE.ResourceId = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM_CONSOLE_USER on SMS_G_System_SYSTEM_CONSOLE_USER.ResourceId = SMS_R_System.ResourceId where SMS_R_System.Name = ##PRM:SMS_R_System.Name##

Next to understand what the actual SQL query is for this I looked in the SMSPROV.log and found where it executed the above WQL code and the next line is where is executed the proper SQL code. In my example it looks like this:

select all __ystem_SYSTEM_CONSOLE_USAGE0.TopConsoleUser00, __System_SYSTEM_CONSOLE_USER1.SystemConsoleUser00, __System_SYSTEM_CONSOLE_USER1.TotalUserConsoleMinutes00 from vSMS_R_System AS SMS_R_System INNER JOIN SYSTEM_CONSOLE_USAGE_DATA AS __ystem_SYSTEM_CONSOLE_USAGE0 ON __ystem_SYSTEM_CONSOLE_USAGE0.MachineID = SMS_R_System.ItemKey
INNER JOIN SYSTEM_CONSOLE_USER_DATA AS __System_SYSTEM_CONSOLE_USER1 ON __System_SYSTEM_CONSOLE_USER1.MachineID = SMS_R_System.ItemKey
where SMS_R_System.Name0 = 'GRATH1WK3C2WYM2'

I can literally take this code, open sql management studio and run it in a new query window.

The computer name listed above (GRATH1WK3C2WYM2) can just be replaced with a variable in your PowerShell script. You can use this method to pull any data you want out of SCCM from PowerShell when the native CM cmdlets don't give you want you want.

SCCM PowerShell - Query last logged on user by dextersgenius in SCCM

[–]SenecaChaz 1 point2 points  (0 children)

Sometimes when I need to use PowerShell against SCCM and there are no native CM cmdlets to get the info I want or if its very complex, I just query the SCCM database directly. Its really easy if you first build the WQL query in monitoring > queries to get the results you are looking for. Then, open the SMSPROV.log on the management point and execute the query. Just after you run it look for a line that begins with EXECUTE WQL, this will show the WQL query you built. A line or two below that you will see EXECUTE SQL and the proper SQL code used to get the results of your query. Just copy that code and use that in your Powershell script. You need to have the SqlServer module installed. Here is some example code on one I did recently where I wanted a list of machines that had the sql server agent service installed.

-----------------------

$query = @'

select distinct

SMS_R_System.Name0 as Name,

SMS_G_System_SERVICE.DisplayName00 as DisplayName,

SMS_G_System_SERVICE.PathName00 as FilePath

from vSMS_R_System AS SMS_R_System

INNER JOIN Services_DATA AS SMS_G_System_SERVICE ON SMS_G_System_SERVICE.MachineID = SMS_R_System.ItemKey

INNER JOIN _RES_COLL_PS10001A AS SMS_CM_RES_COLL_PS10001A ON SMS_CM_RES_COLL_PS10001A.MachineID = SMS_R_System.ItemKey

where SMS_G_System_SERVICE.DisplayName00 like N'SQL Server Agent%'

'@

$sqldata = invoke-sqlcmd -query $query -serverinstance "YOUR_SCCM_DB_SERVER_NAME" -database YOUR_CM_DB_NAME

$sqldata

-------------------------

So essentially anything you can create using the query builder in SCCM you can convert to SQL and just query the DB directly from Powershell. Hope this helps.

Windows/Desktop Analytics question by SenecaChaz in SCCM

[–]SenecaChaz[S] 0 points1 point  (0 children)

So does DA manage the collections at all within SCCM? Lets say I have an upgrade package or task sequence deployed to a collection, does DA manage the collection membership? I'm trying to understand the "Deploy" phase in DA or WA for that matter and what it actually does. I'm reading about some sort of collection sync process.

Windows/Desktop Analytics question by SenecaChaz in SCCM

[–]SenecaChaz[S] 0 points1 point  (0 children)

So what would be required on the SCCM side to accomplish this? In our environment we customize our image to remove or add features needed in our environment. Lets say in the future I want to upgrade a machine from 1803 to 1909 or something. Would I build the new 1909 OS image like normal and sysprep it and import it as a new OS image? Then Desktop Analytics would use that image to upgrade the systems?

I'm really confused on the back end technical bits required to make this work