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, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, DATEDIFF(Day,dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, GETDATE()) AS [Days since last boot], dbo.v_GS_OPERATING_SYSTEM.Caption0 FROM dbo.v_GS_OPERATING_SYSTEM INNER JOIN dbo.v_R_System ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_R_System.ResourceID WHERE dbo.v_R_System.Name0 in (SELECT vrs.Name0 FROM v_r_system AS […]
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 act on the results: declare @LookupString as nvarchar set @LookupString = ‘%’ SELECT vrs.Name0 FROM v_r_system AS vrs JOIN v_GS_INSTALLED_SOFTWARE AS VIS ON […]
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 not accepted. The consensus in Holland at least is that if you can’t afford it, you aren’t going to buy it; that for American’s is […]
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 America. They’ve opened a new section called knuffingen Airport and I’m dying to see it. Then, my Girlfriend and I will spend the next day […]
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 food are different from each other. Holland is a very integrated society, they have succeeded in taking the best parts of a particular culture, and […]
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 are on the east coast, this isn’t a practical thing to do, the distances are so large, and the transit so slow, that you will […]
— 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 Now, last year, I booked a one hour window through Heathrow, a huge mistake since heathrow is gigantic and you have to go through security […]
Macbook Air, CheckExternal Harddrive, CheckNew Aperture Library, check16GB Memory Stick, check Windows 7 in Bootcamp, checkCamera, CheckLenses, Check Adaptors, Check Ok ready to go! But wait, Now I need to pack it all in, so how do I do that? I need to be able to have easy access to all my stuff after unpacking. […]
One thing that bugs me about traveling in general is the risk that when you get to your destination, something, or everything doesn’t work. I’ve done quite a few trips armed only with an iPhone and my trusty Canon SLR, this is a winning combination, because the two don’t need to talk to each other. […]
My now annual trip to Holland is coming up in 7 days; 12 hours 40 minutes, I can’t wait. I am busy preparing stuff for the trip including: Packing, Finding a Parking spot for the car, ensuring that my bills are paid while on vacation. The latter two are easy, the first however, can set […]