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 […]
Month: March 2009
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. […]
Do you go to User Group event? Have you gone out for pints afterwards? Did you know some of the best idea come from the informal after events? Here is a case and point of how a few people (and yes there was woman there too!) can brainstorm and come up with an idea that […]
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
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’
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 […]