April 2009 - Posts

Harrah’s short cut
Saturday, April 25, 2009 4:00 PM

There is a short cut from Harrah’s to the Sands expo.

1. Starting at the Reception desk , exit Harrah’s Turn left

2. Go to the Bus area

3. Near the end of the Bus area, look for the ramp to the Sands Expo (there is a sign)

4. Like this

clip_image002

5. Walk through the parking garage.

6. Take the elevator to the 3rd level

7. You end up near the blue star

clip_image004

8. Go down the Escalator (next to 12 on the map above)

9. Now this is where you should meet up with anyone staying at the Venetian as it is right next to the Elevators to their rooms. See blue star below.

10. Finally keep to the right all the way to the Expo. This shaves off at least half the distance vs going the street way.

clip_image006

Using Datediff & GetDate in WQL
Wednesday, April 22, 2009 9:35 PM

Normally I wouldn’t post a reply to blog post but in this case I had too.

So I was reading this blog Creating a Collection Query based upon Hardware Inventory, and this blog too and I notice that Chris posted a blog about editing your ConfigMgr / SMS database.

  1. You SHOULD never edit your database! This is just asking for trouble.
  2. Editing your database directly is NOT SUPPORTED by Microsoft; it is one thing to use the SDK to make changes to ConfigMgr / SMS but…
  3. The problem he is trying to solved was fixed in SMS 2003 SP1 or SP2.

Now the problem as I see it, is he want to create a collection of all WS that have provided hardware inventory in the last 5 days. Well back in SMS 2003 SP1 (maybe SP2) Getdate(), DateDiff() and DateAdd() were added to WQL functionality. http://msdn.microsoft.com/en-us/library/cc146121.aspx. So there is no need to do this hack and it is unnecessary to do this.

 

In Greg’s blog, He provide the WQL code to:

  • All systems that have reported a LastHardwareScan date within the last 30 days:
  • All systems that have been discovered since midnight:

 

I have created this WQL query to more or less matching what Chris is looking for.

 

select

*

from 

SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceId = SMS_R_System.ResourceId

where

DATEDiff(DD, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan, Getdate()) < 5

by Garth Jones
Filed under: , ,
When was a Software Update applied (SMS 2003)
Thursday, April 16, 2009 8:30 AM

select
    CS.Name0,
    PSE.title0,
    PSE.TimeApplied0
from
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_GS_PATCHSTATEEX PSE on CS.ResourceID = PSE.ResourceID

by Garth Jones
Filed under: , ,
Get out and Vote!!! We need your Help!!
Tuesday, April 07, 2009 9:22 PM

 

As you know, BoF sessions are selected and scheduled based on popular “vote” through the MMS Commnet site.

At this BoF session Steve Kaczmarek and Doug Eby from the Configuration Manager writing team will showcase several  of the newest SuperFlows currently in development or available for publishing. A SuperFlow is a downloadable interactive content model that provides troubleshooting, process flow and other data flow information in an interactive format. We will also demonstrate an authoring template we have developed that can be used to create SuperFlows.

 

This session fell off the list somehow, and now is back on, so if you are attending MMS this year, would consider “voting” for it – and urging your fellow attendees to vote also? Voting is extended through the end of this week.

 

Thanks for your help in this, and for your ongoing support!

by Garth Jones
Filed under:
Coffee and code (latte and lan)
Friday, April 03, 2009 12:07 PM

I got this note this morning that you will find interesting.

BTW It is happening April 7th between 8am and 4 pm, I will be there from 2ish on, before I go to the user Group event that night, which starts at 5:30!

From: Pierre Roman
To: Garth Jones
Subject: Coffee and code (latte and lan)

Hey Garth,
As we discussed this morning, here are the coordinates for the coffee and code.


Coffee and code is an opportunity us and all professionals to meet in a casual settings and discuss technology issues, projects, etc...

It will be at Bridgehead on the corner of Bank and Albert. Here’s the map:
http://maps.live.com/default.aspx?v=2&FORM=LMLTCC&cp=45.419595~-75.700062&style=r&lvl=15&tilt=-90&dir=0&alt=-1000&scene=32822488&phx=0&phy=0&phscl=1&where1=109%20Bank%20Street%2C%20Ottawa%2C%20ON%20K1P%205N5%20&encType=1


The web site for Bridgehead is right here: http://www.bridgehead.ca/  - Free Wifi and lot’s of space.

We hope to see a lot of you there. Thanks for spreading the word for us.
Pierre Roman

software not installed
Wednesday, April 01, 2009 9:47 AM

Select Distinct
    sys.Netbios_Name0,
    sys.User_Domain0,
    sys.User_Name0
FROM
    v_R_System sys
    JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
    sys.ResourceID not in (select sys.ResourceID
                            from
                                v_R_System sys
                                JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
                            where
                                DisplayName0 =  @displayname)

by Garth Jones
Filed under: , , ,

This Blog

Syndication