This handly little SQL Script will get you a count of all Machines in SCCM by Operating System: Â select count ( operating_system_name_and0 ) as Total , operating_system_name_and0 from v_r_system
Posts
declare @collection varchar set @collection = ‘%’ select CS . Name0 , CS . Domain0 , CS . UserName0 , CS . Manufacturer0 , CS . Model0 , CS .
Select Deploymentname , Available , Deadline , cast ( cast ((( cast ( [Compliant] as float ) / ( ISNULL ( [Compliant] , 0 ) + ISNULL ( [Enforcement state
Showing All computers in SCCM that have software installed, with the last boot time listed DECLARE @lookup as varchar (50) set @lookup = ‘%’ SELECT Â Â Â Â TOP (100) PERCENT dbo.v_R_System.Name0,
So, Let’s say you need to see all machines that contain a specific software package, you can use sccm’s gui, or you can do it in SQL, where you can
A side note to the traveler from the Americas, when traveling in Europe, make sure that you are not relying on Credit Cards to pay for stuff, they are simply
Tomorrow, I will be heading off to Hamburg Germany, on a four day trip to amongst others, see the Miniatur Wünderland, a 20 million dollar, miniature model of Europe and
Dutch cuisine, or something. Let me start by saying that I don’t dislike Dutch food at all, but it’s very different, much more so than the way American and Mexican
Vacation is sometimes less about relaxation than exploration; if you get bored, and have the time, take a train or bus somewhere you haven’t been before. In America, unless you
— LAX The flight from Los Angeles (LAX) to Heathrow (LHR) was late into LAX; this started my trip on a wonderful note. The screaming baby, also great. — London