|
|
July 2007 - Posts
-
SELECT SL.CommonName, SL.CommonVersion, SL.CommonPublisher FROM v_LU_SoftwareList SL WHERE (SL.CommonName Like '%oracle%') ORDER BY SL.CommonName 
|
-
select type, count(type) as 'count' from v_SchemaViews group by type order by type 
|
-
select viewname from v_SchemaViews where type = 'inventory' order by viewname 
|
-
This stencil and template provided enable you to create Visio drawings that contain Exchange Server 2007 objects. These shapes include icons for Exchange 2007 server roles, networking, telephony and Unified Messaging objects, Active Directory and directory service objects, client computers and devices, and other Exchange organization elements.
So when will they product a ConfigMgr stencil? 
|
-
SELECT Distinct CS.Name0, CPU.CurrentClockSpeed0, CPU.MaxClockSpeed0 FROM v_GS_COMPUTER_SYSTEM CS, v_GS_PROCESSOR CPU WHERE CS.ResourceID = CPU.ResourceID AND CPU.REsourceID not IN (select ResourceID from v_GS_PROCESSOR CPU group by ResourceID having count(CPU.ResourceID) > 1) AND CPU.MaxClockSpeed0 < '1800' 
|
-
select interfacetype0, count(interfacetype0) as 'count' from v_GS_DISK group by interfacetype0 
|
-
-
A year in review
User group meeting
Door Prize
Fall 2007 Certification Study Session
Fall 2007 User group meeting
Links
A year in review
This last year was one of our best years to date, our average attendance at user group meeting is up, and our mailing list registration is up. OWSUG was able to participate in the Vista launch along with Ottawa .NET Community, at the Congress Center. We completed two more study groups (70-291 and 70-294). We worked with the Ottawa .NET Community and now both user groups have their study group meeting held on the same night at CTE Solutions. All in all it was a good year.
Here are a few things to note about the OWSUG.
Mailing list members: 464
Forum Members: 346
Study group: 2
Study group members: ~30
Study group meetings: ~25 meetings
Let’s hope that next year is even better!
July 31st 2007 User Group Meeting
Topic: Meet and Greet
Description: This is your chance meet your peers and to network, there is no formal presentation.
Location:
Darcy McGees
44 Spark Street
Ottawa, Ontario, K1P 5A8
Map: http://maps.live.com/default.aspx?v=2&cp=45.423244~-75.696521&style=h&lvl=17&tilt=-90&dir=0&alt=-1000&encType=1
Agenda:
6:00 p.m. Event registration
7:30 p.m. Door Prizes.
Notes: Finger foods will be severed, Please RSV.
RSVP: https://www.clicktoattend.com/invitation.aspx?code=119505
Door Prize
For our last user group meeting on July 31, we have lots of exciting door prizes to give away. The Grand Prize donated by CTE Solutions is a free course “Installing and Configuring the Windows Vista Operating System” a value of over $1,500! You must be there to win!
The OWSUG would like to thank CTE Solutions for all of their support throughout the year to both the study group and user group, without them it would have been a much bigger struggle to keep things going!
Fall 2007 Certification Study Session
MCTS: Configuring WINDOWS VISTA Client (Exam 70-620)
Interested in getting certified on Microsoft’s latest operating system?
Join the OWSUG certification study group as we dive deep into the next generation Windows technology!
Session runs from September 10th to December 10th.
Contact, see Brad at the July 31 user group meeting or email certify@owsug.ca for info on how to sign up.
Fall 2007 User group meeting
With the fall brings a start to a new user group season, with the release of so many new products the outlook for many exciting presentations are to come such as:
Overview of System Center Configuration Manager
Overview of System Center “Service Desk”
Vista deployment using BDD
Again we will try to have our meeting on the 3rd Thursday of each month. As always we are looking for presenters, if you are interested in becoming a presenter, please contact Admin@owsug.ca.
Links
OWSUG.ca Web Site http://owsug.ca/
OWSUG.ca Mailing list http://lists.owsug.ca
OWSUG.ca Blog http://owsug.ca/blogs/MainFeed.aspx
OWSUG.ca Forums http://owsug.ca/forums/default.aspx 
|
-
This question was asked yesterday
"...The SiteSystem and SiteObject columns return data that looks like this:
MSWNET:\\Server\Share\
What I expect to see, (what I see in the console) is this:
\\Server\Share
Can anyone point me in the correct direction?"
Here is the answer
Select replace (left(SiteSystem,charindex('MSWNET',SiteSystem)-3),'["Display=',''), SiteCode, replace (left(SiteObject,charindex('MSWNET',SiteObject)-3),'["Display=','') as 'Storage Object', Role, cast (BytesTotal/1024/1024 as varchar) +' GB'as "Total Space", cast (BytesFree/1024/1024 as varchar) +' GB'as "Free Space", cast (PercentFree as varchar) + '%' as "Percent Free Space", DownSince From v_SiteSystemSummarizer SSS Where Role = 'SMS Distribution Point' 
|
-
I’m not sure how this SQL task was created on only some of the site servers and not others, I could have created it myself however, for those that don’t have it. This is how you create it.
From you SMS console:
Drill down to “Site Database | <your site code> | Site Settings | Site Maintenance | SQL Commands”
In the results pane, right click and select new | SQL command
Enter “Regenerate SQL Views” within the Name filed
Enter “EXEC sp_RenewSMSSchemaViews” within the SQL command filed
Optional enter the location of where the log file should be stored.
For the Schedule, I like it to run every day and I pick 6:00 am for this to run.
Now your windows should look something like this.
 
|
-
Well like thousands of other people last night I picked up my copy of “Harry Potter and the Deathly Hallows”, did you? 
|
-
SELECT DP.ServerName, DP.SiteCode, case DP.IsProtected when 1 then 'True' else 'False' end as 'Protected' FROM DPInfo DP 
|
-
I was discussing with a friend how to determine the over all hot fix complicacy level, the other day, hence yesterday’s query. But what I wondering was why my test lab was not at 100% compliancy. It will take a while for that to happen only because I have not rolled out IE 7 to Windows XP systems yet. Anyways I used this query to determine which PCs were not up to date.
SELECT CS.Name0,
Patch.ID0,
Patch.Product0,
Patch.Severity0,
Patch.Status0,
Patch.TimeAuthorized0,
Patch.TimeDetected0,
Patch.Title0,
Patch.Type0
FROM v_GS_COMPUTER_SYSTEM CS,
v_GS_PATCHSTATEEX Patch
WHERE Patch.ResourceID = CS.ResourceID
AND Patch.Status0<>'Installed' 
|
-
Set Nocount OFF
Declare @Installed as int
Declare @Total as int
Declare @Per as Float
set @Installed = (SELECT SUM(CASE WHEN patch.Status0 = 'Installed' THEN 1 ELSE 0 END) as 'Installed' FROM v_GS_PATCHSTATEEX patch, v_GS_SYSTEM SYS where SYS.systemrole0 = 'server' and SYS.ResourceID = Patch.ResourceID)
set @Total = (SELECT count(patch.Status0)FROM v_GS_PATCHSTATEEX patch, v_GS_SYSTEM SYS where SYS.systemrole0 = 'server' and SYS.ResourceID = Patch.ResourceID)
set @Per = (select Sum(@installed*100/@total))
SELECT @Installed as 'Installed',
@total as 'Total',
@Per as 'Percent' 
|
-
SELECT Distinct
SecurityObjInstances.InstanceKey AS 'object',
SecurityObjInstances.UserName,
vSecurityClassPermissions.PermissionName
FROM SecurityObjInstances SecurityObjInstances,
vSecurityClassPermissions vSecurityClassPermissions
WHERE vSecurityClassPermissions.ObjectKey = SecurityObjInstances.ObjectKey
AND vSecurityClassPermissions.UserName = SecurityObjInstances.UserName
ORDER BY
SecurityObjInstances.InstanceKey,
SecurityObjInstances.UserName,
vSecurityClassPermissions.PermissionName
|
-
SELECT SCU.TopConsoleUser0, Sum(SCU.TotalSecurityLogTime0/60/24) AS 'Total Security Log Time' FROM v_GS_SYSTEM_CONSOLE_USAGE SCU GROUP BY SCU.TopConsoleUser0 
|
-
SELECT SC.SoftwareCode, SC.Family, SC.Category FROM v_LU_SoftwareCode SC WHERE SC.Category='eBook' 
|
-
SELECT SCU.TopConsoleUser0, Sum(SCU.TotalConsoleUsers0) AS 'Total Console' FROM v_GS_SYSTEM_CONSOLE_USAGE SCU GROUP BY SCU.TopConsoleUser0 
|
-
SELECT SC.SoftwareCode, SC.Family, SC.Category FROM v_LU_SoftwareCode SC WHERE SC.Category='Screensaver' 
|
-
Information Worker Solutions, Office Systems Desktop Deployment Partner of the Year Winner
| • |
Compugen Richmond Hill, Canada |
The Information Worker Solutions, Office Systems Desktop Deployment Partner of the Year Award recognizes the exceptional partner that has excelled in offering breakthrough Microsoft Office system solutions. The winning partner’s technology and marketing offerings have increased its customers’ employee productivity and assisted them in connecting with their business partners and customers. The winning partner’s innovative thinking has helped solve a technical challenge or helped address its customers’ business needs and empower their employees, and has had a unique and positive impact on customers’ business pain points.
http://www.microsoft.com/presspass/press/2007/jul07/07-12MSPartnersWinnerPR.mspx
Now Compugen has an award for BDD and they have Rod Kruetzfeld the author of SMS 2003 Pro. (see my book review) http://smsug.ca/blogs/garth_jones/archive/2007/04/25/286.aspx
<Sung to the theme song from ghostbusters> “Now who are you going to call, Compugen”
|
-
Compugen Counted Among Top Finalists for the 2007 Microsoft Partner of the Year Award in Information Worker Solutions, Office Systems Desktop Deployment.
http://www.compugen.com/news/newsitems/MSIWFinalistENv3.pdf
And one of very own is a key player on the team that got nominated for this award.
|
-
-
Chris (no content) Mosby found this very cool Virtual Server tool.
Chris’ blog post
Virtual Machine Remote Control Client Plus (VMRCplus)
VMRCplus is a tool for both configuration management of Virtual Server and remote control of virtual machines. It allows for local and remote management of Virtual Server and supports simultaneous management of up to 32 Virtual Server hosts.
Remote control sessions of virtual machines are grouped in a single window using Tab pages. The interface enables sorting virtual machines based on various properties like name, status and description. Multi-select of virtual machines enable you to perform actions to change their status or open remote control sessions all at once.
VMRCplus is a Windows application and does not require IIS to manage Virtual Server.
This also led me to “Microsoft Virtual Server 2005 R2 SP1 - Enterprise Edition”
Download the service pack 1 for Microsoft Virtual Server 2005 R2 Enterprise Edition. Virtual Server 2005 R2 SP1 is a cost-effective and well supported server virtualization technology for the Windows Server System™ platform. As a key part of any server consolidation strategy, Virtual Server increases hardware utilization and enables organizations to rapidly configure and deploy new servers. 
|
-
SELECT CS.Name0, BIOS.SerialNumber0, ES.SerialNumber0 FROM v_GS_COMPUTER_SYSTEM CS, v_GS_PC_BIOS BIOS, v_GS_SYSTEM_ENCLOSURE ES WHERE BIOS.ResourceID = CS.ResourceID AND ES.ResourceID = CS.ResourceID AND BIOS.SerialNumber0 !=ES.SerialNumber0 
|
-
SELECT SC.SoftwareCode, SC.SoftwareID, SC.Family, SC.Category FROM v_LU_SoftwareCode SC WHERE SC.Category='Password Cracker' 
|
-
SELECT MOD.MaxBaudRateToPhone0,
Count(MOD.MaxBaudRateToPhone0) AS 'Count of MaxBaudRateToPhone0'
FROM v_GS_MODEM_DEVICE MOD
GROUP BY MOD.MaxBaudRateToPhone0
|
-
SELECT MOD.Name0, Count(MOD.Name0) AS 'Count of Name0'
FROM v_GS_MODEM_DEVICE MOD
GROUP BY MOD.Name0
|
-
My test database has External Modem, Internal Modem, and Null Modem
SELECT MOD.DeviceType0,
Count(MOD.DeviceType0) AS 'Count of DeviceType0'
FROM v_GS_MODEM_DEVICE MOD
GROUP BY MOD.DeviceType0
|
-
SELECT SC.SoftwareCode, SC.Family, SC.Category FROM v_LU_SoftwareCode SC WHERE SC.Category='Malware' ORDER BY SC.SoftwareCode 
|
-
SELECT SC.SoftwareCode, SC.Family, SC.Category FROM v_LU_SoftwareCode SC WHERE SC.Category='Spyware' 
|
-
The NM3.1 is now available on http://connect.microsoft.com featuring wireless sniffing and an easier way to create filters using "Right Click Add To Filter". Here is a list of features that are new to NM3.1.
What's New in Network Monitor 3.1?
· Wireless (802.11) capturing and monitor mode on Vista - With supported hardware, (Native WIFI), you can now trace wireless management packets. You can scan all channels or a subset of the ones your wireless NIC supports. You can also focus in on one specific channel. We now show the wireless metadata for normal wireless frames. This is really cool for t-shooting wireless problems. See signal strength and transfer speed as you walk around your house!
· RAS tracing support on Vista - Now you can trace your RAS connections so you can see the traffic inside your VPN tunnel. Previously this was only available with XP.
· Right click add to filter - Now there's an easier way to discover how to create filters. Right click in the frame details data element or a column field in the frame summary and select add to filter. What could be easier!
· Microsoft Update enabled - Now you will be prompted when new updates exist. NM3.1 will occasionally check for a new version and notify you when one is available.
· New look filter toolbar - We've changed the UI related to apply and remove filters. You can now apply a filter without having to UN-apply it first.
· New reassembly engine - Our reassembly engine has been improved to handle a larger variety of protocol reassembly schemes.
· New public parsers - These include ip1394, ipcp, ipv6cp, madcap, pppoE, soap, ssdp, winsrpl, as well as improvements in the previously shipped parsers.
· Numerous Bug Fixes - We've taken your reported problems on the connect site and fixed many of the confirmed bugs.
· Faster Parser Loading - We've significantly improved the time it takes to load the parsers. Now rebuilding takes a fraction of the time it used to.
How do I get NM3.1?
NM3.1 is currently available on http://connect.microsoft.com. You will need to sign in with your passport account and participate in the Network Monitor 3 project, if you haven't already. Once you do this, you'll have access to the latest download. This will also give you access to our bug filing process and access to our news groups for getting support. We will also release NM3.1 on the Microsoft Download site within the next few weeks.
|
-
|
|
|