Month – March 2009

List computers by AV software

SELECT DISTINCT     R.Netbios_Name0,     R.User_Name0,     WS.lastHWScan,     CASE         WHEN ARP.DisplayName0 = ‘Symantec Endpoint Protection’ THEN ‘*’         else ‘ ‘     END As SEP,     CASE         WHEN ARP.DisplayName0 = ‘McAfee VirusScan Enterprise’ THEN ‘*’         else ‘ ‘     END As Mcafee,     ‘ ‘ As ‘No AVS’ FROM      dbo.v_R_System […]

Are you planning on taking 70-089?

  What is covered on the exam http://www.microsoft.com/learning/en/us/exams/70-089.mspx   Here are the type of questions you should expect to see, Make sure to download the demo software. http://smsug.ca/blogs/garth_jones/archive/2008/09/16/microsoft-exam-questions.aspx   Here is evaluation version of testing software that you can purchase. http://www.transcender.com/product.aspx?product_id=Cert-70-089&Search=1   Here are about 30 Q&A that will help you study for the exam. […]

Adding Publisher

Select     SOFT.ProductName0 as ‘Browser Name’,     Soft.Publisher0,     Count(SOFT.ProductName0) as ‘Count’ FROM     v_GS_INSTALLED_SOFTWARE_CATEGORIZED SOFT WHERE     SOFT.ProductName0 LIKE ‘Mozilla Firefox%’     OR SOFT.ProductName0 LIKE ‘Safari’     OR SOFT.ProductName0 LIKE ‘%Internet Explorer%’     OR SOFT.ProductName0 LIKE ‘%Google Chrome%’ Group by     SOFT.ProductName0,     Soft.Publisher0

Monitoring a Windows Service

select Distinct CS.Name0,  SER.Displayname0, SER.Started0, SER.StartMode0, SER.State0 from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_SERVICE SER, dbo.v_FullCollectionMembership FCM where CS.ResourceId = SER.ResourceID and CS.ResourceId = FCM.ResourceID and SER.displayname0 like ‘%firewall%’ and (SER.State0 != ‘Running’ or Isnull(SER.State0,”)=”) and FCM.CollectionID = ‘SMS00001’

Microsoft Skills Week

Hi Everyone I just got a email from the team at CTE. They want to give the OWSUG first crack at their Microsoft Skills Week sessions! Below are the details! We’ve found what you’re looking for… During the week of April 14th-17th we’ll be hosting a Microsoft Skills Week in Ottawa and you’re invited!  Choose […]