|
|
October 2008 - Posts
-
SELECT
COL.CollectionID,
COL.Name,
COL.Comment,
CTSC.parentCollectionID
FROM
dbo.v_Collection COL,
dbo.v_CollectToSubCollect CTSC
WHERE
CTSC.subCollectionID = COL.CollectionID 
|
-
When troubleshooting BITS, use GPResult to find out which policy is setting the BITS settings. From a Administrator CMD, execute the following: gpresult /SCOPE COMPUTER /H GPR.html Then open the GPR.html 
|
-
At last week’s user group meeting, I hand out a quick survey of the event and what topic we should do next. The results are fairly interesting: - Take more that 10 minutes to write a survey and have someone else proof read it. (Foot) :-)
- The session content applied to everyone
- The session was not too technical
- Most people don’t care about if we server food
- Some will even pay for their own
- Most people still don’t want sale pitch presentation from vendors
- Unless the vendor provide an “open bar” – I liked that note.
- There is interest for an Exchange Study group
- The location is convenient to everyone.
- A number of people would like to volunteer to help out the OWSUG
Also interesting to note that the average client base was over 5000 client. So what does this mean, well I think this it means - We need to do surveys more regularly
- Work more with the other User Groups
- Determine if there is a enough interest for a Exchange Study group
- Find 3 Co-leaders to run this study group
- When they are ready, create a forum, mailing list and blog for the group
Topic of interest to the User Group: - Virtual Machine Manager and Hyper-v
- SharePoint
- Server performance
- Exchange
Now I have to find someone to present them. :-) 
|
-
The Creating Custom Reports by Using Configuration Manager 2007 SQL Views documentation is out. This documentation provides the information to help you create custom reports, determine which Configuration Manager 2007 SQL views contain the information you need for your reports, and identify the path between the necessary SQL views and determine what columns can be used to join them. Overview Microsoft System Center Configuration Manager 2007 queries SQL Server views in the Configuration Manager site database when retrieving the information displayed in reports. The Configuration Manager site SQL database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. The database also contains objects that represent Configuration Manager 2007 items such as advertisements, software update deployments, configuration baselines, reports, and status messages. Configuration Manager administrators need to understand the different categories of the SQL views, what information is stored in each view, and how the SQL views can be joined to one another to create reports that return the desired information. The Windows Installer CreatingCustomReportsByUsingSQLViews.msi package provides information that will help you to create custom reports, determine which Configuration Manager SQL views contain the information you need for your reports, and identify a path between the necessary SQL views and determine what columns can be used to join them. The download package includes the following files: - Before You Use – Readme document (BeforeYouUse_Readme.doc):
Provides information about how to use the other documents in the Windows Installer download package.
- Using Configuration Manager 2007 SQL Views to Create Custom Reports help file (CM2007CustomReports.chm):
Provides an overview of the Configuration Manager 2007 SQL view schema and SQL views, an overview of the existing reports and associated reporting procedures, sample SQL statements for each Configuration Manager SQL view category, scenarios for creating custom reports, exercises for creating custom reports, an overview for writing report SQL statements, and an overview of the Configuration Manager Provider WMI schema. This documentation will be your main resource throughout the process of creating your custom report.
- Configuration Manager 2007 SQL View Schema Microsoft Visio document (CM2007SQLViewsSchema.vsd):
Provides the Configuration Manager 2007 SQL views schema, organized by category.
- Configuration Manager 2007 SQL Views Excel spreadsheet (CM2007SQLViews.xls):
Provides a list of the Configuration Manager 2007 SQL views with descriptions, a list of the SQL views and columns ordered by SQL view name, and a list of the SQL views and columns ordered by column name. http://www.microsoft.com/downloads/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en&displaylang=en 
|
-
Free Evening Event @ Microsoft Ottawa Thursday, November 13th 5:15 - 8:00 PM Feature Presentation: Upgrading and Migrating to SQL Server 2008 Best Practices and Lessons from the Field, Damir Bersinic Damir will be in town for the Ottawa stop of the Align IT tour on November 13th. He will be taking this opportunity to share some of his SQL Server 2008 experience with the Ottawa community. Join us for what promises to be a fantastic presentation! Speaker: Damir Bersinic, Microsoft Canada 
Damir As an IT Pro Advisor for Microsoft Canada, Damir is passionate about reaching out to and engaging with the IT Pro community across Canada. He focuses on working with a broad range of audiences within the IT Pro community to foster relationships and convey Microsoft technologies and solutions. He is proud to be able to leverage his real life, hands-on experience to relate to the challenges faced by the IT Pro community today. Damir is an integral part of the Microsoft team that drives awareness, education and training through events and by directly engaging with Canada's professional communities, including IT managers, infrastructure specialists and architects as well as systems integrators, independent software vendors (ISVs) and community leaders. Product Showcase (15 minutes): SQL Response - Red Gate Software, David E. Myers 
No flashing lights. No repetitive emails. No complicated configuration required. Only the intelligent alerts and diagnostic data you need to resolve problems on your SQL Servers sooner. All from a single, intuitive interface. SQL Response monitors the health and activity of your SQL Servers, so you can work proactively to resolve the problems that matter most. See how no-nonsense monitoring from Red Gate's new SQL Response™ can help you make the most of your office hours. Speaker: David E. Myers, Upper Canada District School Board 
David David is a DBA and Developer at the Upper Canada District School Board (Brockville, ON) and is the OttawaSQL.net Executive Director for 2008. He primarily works with SQL Server but is increasingly working in the SharePoint data integration world. David will be presenting the session Information and Collaboration in One Place – Reporting Services Integration with SharePoint at Tech Days Canada 2008 in Montreal and Ottawa. REGISTRATION: LOCATION: RSVP: Event Registration Arrival: 5:15 PM to 5:30 PM Presentation: 5:30 PM to 8:00 PM Refreshments: Pizza and Pop Microsoft Ottawa, World Exchange Plaza 100 Queen Street, Suite 500, Ottawa EVENT SPONSORS: 
EVENT PARTNERS: 
 
OttawaSQL.net is a community group of Ottawa area developers and IT professionals. We share an interest in Microsoft’s data technologies especially: SQL Server, SharePoint, PerformancePoint, Workflow Foundations, LINQ, ADO.NET and Entity Framework. 
|
-
SELECT
CS.UserName0
Into
#tmp
FROM
dbo.v_GS_Computer_system CS
group by
CS.UserName0
Having
Count(CS.UserName0) > 1 SELECT
CS.Name0,
CS.Manufacturer0,
CS.Model0,
CS.UserName0
FROM
dbo.v_GS_Computer_system CS,
#tmp
Where
#tmp.UserName0 = CS.UserName0
or CS.UserName0 != Null
Order by
CS.UserName0,
CS.Name0,
CS.Manufacturer0,
CS.Model0 Drop table #tmp 
|
-
It not even November yet and we are getting ~20 cm (~8 inch)of snow in the next 24 hours! The funny part is, last night they were calling for 35+ cm! 
|
-
Have you see the new game MS released to Vista Ultimate? Don't play Tinker unless you have a few hours to kill!! 
|
-
TODAY is the second and last week of EXAM Review day! Please remember to sign up for tonight session and good luck on your exam! 
|
-
Listed in order: - Show Desktop
- Internet Explorer
- Outlook
- Live Writer
- Microsoft Query
- Microsoft SQL Server Management Studio
- SnagIt 8
- ConfigMgr help file
- SCVMM Console
- VMCRPlus
- Hyper-V Manager
- ConfigMgr SDK help file
- ConfigMgr Console
- OpsMgr Console
|
-
Yesterday I was talking about the System Center Configuration Manager Enterprise Administrator, anyways I was quickly asked what I thought would be appropriate for OpsMgr. OpsMgr is a bit different than ConfigMgr, I don’t think that you need to know about Workstation, Licensing or Packaging (as much). However saying that, it should NOT make getting the OpsMgr Enterprise Admin certification any easier! On the contrary you are still going to need about the same number of exams as the ConfigMgr Enterprise Admin and there is some overlap between the two. Server OpsMgr Enterprise admin must know about IIS, PKI, Networks, DHPC, DNS, etc. even more so that ConfigMgr therefore they should know 70-640, 70-642, and 70-643 And either 70-646 or 70-647 SQL SQL is important part of OpsMgr both from it using it and from the of need of creating reports for management. It just can’t be overlooked. 70-431 or 70-432 OpsMgr exam of course 70-400 Again I’m sure that some people will say I have made this too hard to achieve, again this maybe so but as OpsMgr Enterprise Admin you will need to know everything server related and for that matter you still should know about workstations too! The question that will come up is 6 exams too much? Unlike a regular Win2k8 Enterprise Admin, OpsMgr Admin need to know far more to get the job done, so Yes 6 exams is fair! For that matter during my discussion over what a OpsMgr Enterprise Admin should know the question about Unix and LAN/WAN/Networking equipment came up. I have deliberately not added those in but you will find that many OpsMgr Enterprise Admin require this knowledge too. BTW If the was adopted today, I would be missing a one of these exams myself! I would still need the OpsMgr exam! 
|
-
Well I wrote 70-403 this morning, now it is time for the hard part. waiting for the exam results! I’m hoping that I passed it. I will know in about 8 weeks or so. Now I’m back to continue working on 70-647. 
|
-
Today I was watching the Live meeting on System Center exams. Well I thinking that MS needs certification for Enterprise ConfigMgr Admins and here are the exams that I think that you need to get this certification and some of the reasons why. Workstation If a ConfigMgr Admin does not know about workstation then what are they doing working with ConfigMgr. 70-620 or maybe CHAMP BDD In this day and age , OS Deployment is an important part of ConfigMgr as an Enterprise Admin you must know this. 70-624 or 70-622 Server Just like workstations, ConfigMgr Enterprise admin must know about IIS, PKI, Networks, DHPC, DNS, etc. one of 70-640, 70-642, 70-643 SQL SQL is such an important part of ConfigMgr both from it using it to need create reports for management. It just can’t be overlooked. . 70-431 or 70-432 Licensing Compliancy is one of thing topic that is always over looked. As an Enterprise ConfigMgr admin you will get ask “how many of X do we have” but what is missed is ConfigMgr Eadmin need to help management not violate their licensing agreement, Therefore this need to know about this. 70-122 or CSAM Packaging If you follow the newsgroup, mailing list and forum, you will see that packaging is one of the more important topic. Windows Installer Certification Program Or Wise Package Studio 7 Or ??? ConfigMgr exam of course 70-401 I’m sure that some people will say I have made this too hard to achieve, this maybe so but as ConfigMgr Enterprise Admin you will need know about just about everything! BTW If the was adopted today, I would be missing a few of these myself! I would need the Packaging and Licensing exams both would be at the top of my list if it was adopted today! 
|
-
How to fix the font issue with CHM files!!!! This has been bugging me for a while so much so that I begged one of the docs team member to help me fix the issue!!! ![clip_image002[4]](http://smsug.ca/files/TipoftheDay_BFB4/clip_image0024_thumb.jpg)
Notice that the text above is unreadable!!!! Fix:
1. From the CHM Menu click Options
2. Click Internet Options
3. From Internet Options window click Accessibility button
4. Check box Ignore font size specified on Webpages
5. Click OK
That's it! 
Look I can read the chm file now!!! It only took a few hours of surfing to find this one piece of information!! Now I can continue troubleshooting SCVMM 2008 Beta! those 1612 errors are a pain in ...!!! 
|
-
TODAY is the first week's EXAM Review day! Please remember to sign up for tonight session. 
|
-
select distinct
R.Netbios_Name0,
R.User_Name0,
R.AD_Site_Name0,
R.Active0,
R.Client0,
R.Obsolete0,
ARP.DisplayName0,
ARP.Version0,
R.Operating_System_Name_and0
from
v_R_System R inner join v_GS_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID = R.ResourceId
where
ARP.DisplayName0 like 'AutoCAD%'
or ARP.DisplayName0 like 'Autodesk%'
or ARP.DisplayName0 like 'DWG TrueView%'
or ARP.DisplayName0 like 'Raster Design%'
or ARP.DisplayName0 like 'Volo view%'
and ARP.DisplayName0 != 'Autodesk Design Review 2008'
order by
ARP.DisplayName0,
R.Netbios_Name0 
|
-
What are AD FS four service roles? Answer: - Federation Service
- Federation Service Proxy
- Claims-Aware Agent
- Windows Token-Based Agent
|
-
This is the last week of reading before exam, review! Please make sure that you sign up for the exam review sessions, so we know how many people are planing to attend. This weeks reading for the self study group is: | 17.2 Confiruation and Usering Activie Directoru Federation Services | 21 | 21 | 
|
-
What are AD FS four service roles? 
|
-
As I posted the other day I will be speaking at Tech-days, Anyways each track is colour coded and both Brad and I will be presenting in the “Green” track in Ottawa. Why I’m on telling you this, well it is simple, when you arrive at Techdays you will be asked which Track button you would like to wear that day, this allows you to find others within same track. So remember that the "Green" track is the best track of them all! This is what the buttons look like at least for speakers. 
|
-
Well this morning I did it. I became a MCITP: Windows Server 2008, Server Administrator, it helped that I have 20 hours last weekend while drive to/from a wedding in “Soo” to finish reading the 70-646 MS Press book! I also made a few more decision about exams. 70-089, Well I’m already an MCSE and no client will ever ask if I have written and passed that exam so I am officially dropping this one from my list of exam to work on, there is no point. However if I am ever bored and have money “burning a hole in my pocket”, I would write it in a heartbeat. 70-656, I’m dropping this one too. I don’t see the point of working on this one when MDOP v2 has been released. Plus I don’t need the charter member SWAG. If you have been following my exam process you might asked yourself, what does he still have on this list. And the answer is 70-400, 402 (if released), 403 (in beta now), and 647. Even though Brad & Rory want to me do the 70-400 next, I not I am going to work on it (yet), instead I am working on 70-647 exam, I figure I’m in the groove for Win 2008 exams and there is ALLOT of overlap between the exams so don’t stop now! BTW Did you know that the MS Press for 70-647 is 572 page but the 70-646 is 768 page!!! 15 Exams down, 3 (+1) exams to go. 
|
-
What AD RMS roles has read-only access to the AD RMS logs? Answer: The AD RMS roles with read-only access to the AD RMS logs is “AD RMS Auditors” 
|
-
SELECT
ARP.ProdID0,
ARP.DisplayName0,
ARP.Version0,
CS.Name0
FROM
dbo.v_Add_Remove_Programs ARP,
dbo.v_GS_COMPUTER_SYSTEM CS
WHERE
ARP.ResourceID = CS.ResourceID
AND CS.Name0 Like 'AB%' 
|
-
Do you want 3 Free Exam vouchers? Well sign-up for the Beta Exam of 70-113 aka 70-640 and you could get 3 free exam vouchers. Here are the details. New Virtual Lab based Exam 70-113: TS: Windows® Server 2008 Active Directory, Configuring - Registration open till October 25th for testing!!!! Want to help us out with the new Virtual Lab based exams!!! This is NOT a normal beta exam and so make sure you read the information in BLUE below. This is a pilot to test the exam experience only. Still interested? Then read on below!! Responding to a ton of positive and productive feedback and many customer requests, Microsoft extends the registration for exam 70-113 till October 25th. Call to your near test centers before October 25th to learn and experience it now to prepare for your experience during scored testing. The new pilot exam 70-113: TS: Windows® Server 2008 Active Directory, Configuring tests candidate’s abilities to actually perform tasks and solve problems in virtual lab environment like they would do it normally in a real world. We are pleased to offer you the opportunity to experience this pilot exam at no charge and obviously we are eager to receive your opinion. Now virtual lab based pilot Exam 70-113 is available worldwide, with a high concentration of test centers ready to receive registrations for this pilot exam in Ireland, Singapore, Canada, Malaysia, Australia, New Zealand, Philippines, Saudi Arabia, UK, Egypt, UAE, South Africa, US, India, Eastern Europe, Russia (Moscow), China. Upon completion of this pilot exam, the first 3000 candidates will receive 3 free exam vouchers that can be used to register for any Microsoft Certification exam delivered at a Prometric testing center. The voucher will be distributed electronically 4 weeks after end of Pilot. This pilot exam will not provide you with a score as with normal beta exams. This pilot is a test of the exam experience, so only a portion of the final exam will be presented to you during this pilot. This pilot exam will not be added to your transcript and you will need to take the exam in its released form in order to be awarded the credential. Find exam preparation information: http://www.microsoft.com/learning/exams/70-640.mspx Registration Information You must register at least 7 days prior to taking the exam. Register before October 25th to take the exam before October 31st.
Please use the following promotional code when registering for the exam: H640 (promo code is active till October 31st)
Receiving this invitation does not guarantee you a seat in the pilot; we recommend that you register immediately. Source: http://blogs.technet.com/johnbaker/archive/2008/10/08/new-virtual-lab-based-exam-70-113-ts-windows-server-2008-active-directory-configuring-registration-open-till-october-25th-for-testing.aspx 
|
-
Microsoft Exchange Server 2007 provides many enhancements to help organizations better manage their email, extend their messaging platform with Unified Communications technologies, and provide greater reliability and security. IT Pros are challenged with upgrading or migrating their existing email platform to Exchange 2007, while at the same time being keenly aware of the fact that email is something that can never go down. This session will teach you the best practices to migrate to Exchange 2007 so that you can be successful at acquiring the benefits of Exchange 2007 by a well-planned and executed migration. We will dive into migration and transition planning where you will learn scenarios to migrate environments such as Exchange Server 5.5, 2000, and 2003, Novell GroupWise and Lotus Domino to Exchange Server 2007. You will be trained to recognize and plan which of the different migration scenarios is best for you. You will learn what’s required to support multi-client environments (Outlook 2003 and earlier, as well as Outlook 2007) and what is required for coexistence planning.
About the Speaker:
Richard Claus is a bilingual Senior IT Pro Advisor working for Microsoft Canada. Based in Ottawa, Ontario, Rick is focused on engaging "the IT Pro community" by establishing relationships and giving support to various IT Professional focused initiatives, user groups and professional associations. He is very excited to have a position where he is empowered to reach out and share his passion for technology with the Canadian IT Professional community.
Prior to joining Microsoft, Rick most recently worked as an Enterprise Architect at a Microsoft Gold Partner. His previous design experience includes Virtualization strategies, Active Directory implementations and migrations, highly available Exchange messaging solutions, and overall systems management and interoperability. Besides design and consulting work, Rick brings over 17 years of IT experience, ranging from front line "in the trenches" admin duties, to training/mentoring/facilitating individuals and teams on how to use technology more effectively in their organizations. Rick is an integral part of the Microsoft community team which drives awareness, education and training through special in person and online events. In addition to planning and delivering these events, his group directly engages with Canada's professional communities, including IT managers, infrastructure specialists and architects, systems integrators, independent software vendors (ISVs) and community leaders. Location:
Microsoft Canada Co.
100 Queen Street Suite 500
Ottawa, Ontario
K1P 1J9
Agenda:
5:00 p.m. Event registration
5:30 p.m. Presentation
7:30 p.m. Q & A
8:00 p.m. Door Prizes Notes: Pizza and Pop will be served, Please RSVP to help us order enough of both.
RSVP: http://www.clicktoattend.com/?id=132403
|
-
SELECT
UI.MaxExecutionTime,
Count(UI.MaxExecutionTime)
FROM
dbo.v_UpdateInfo UI
GROUP BY
UI.MaxExecutionTime
ORDER BY
UI.MaxExecutionTime 
|
-
SELECT
CS.Name0,
CS.UserName0,
SF.FileName,
SF.FileSize,
SF.FileModifiedDate,
SF.FilePath
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_SoftwareFile SF,
dbo.v_GS_SYSTEM SYS
WHERE
SYS.ResourceID = CS.ResourceID
AND SF.ResourceID = CS.ResourceID
AND SYS.SystemRole0='Workstation'
AND SF.FileName Like '%.pst'
Order By
CS.Name0,
SF.FileName 
|
-
This weeks reading for the self study group is: | 16.2 Configuring and Using Directory Right Management Services | 16 | 45 | | 17.1 Understadnign Active Directory Federation Services | 29 | | 
|
-
What AD RMS roles has read-only access to the AD RMS logs? 
|
-
What is CRL? Answer: Certificate Revocation List 
|
-
Set nocount on
CREATE TABLE #CDisk (resourceid varchar(64), size0 varchar(64), freespace0 varchar(64)) CREATE TABLE #DDisk (resourceid varchar(64), size0 varchar(64), freespace0 varchar(64)) CREATE TABLE #CPU1 (resourceid varchar(64), currentclockspeed0 int, maxclockspeed0 int) CREATE TABLE #CPU2 (resourceid varchar(64), currentclockspeed0 int, maxclockspeed0 int)
INSERT INTO #CDisk
select distinct vrs.resourceid, dsk.size0, dsk.freespace0 from v_R_system vrs inner join v_gs_logical_disk dsk on vrs.resourceid = dsk.resourceid where dsk.name0 = 'C:'
INSERT INTO #DDisk
select distinct vrs.resourceid, dsk.size0, dsk.freespace0 from v_R_system vrs inner join v_gs_logical_disk dsk on vrs.resourceid = dsk.resourceid where dsk.name0 = 'D:'
INSERT INTO #CPU1
select vrs.resourceid, cpu.currentclockspeed0, cpu.maxclockspeed0 from v_R_system vrs inner join v_GS_Processor cpu on vrs.resourceid = cpu.resourceid where cpu.deviceid0 = 'CPU0'
INSERT INTO #CPU2
select vrs.resourceid, cpu.currentclockspeed0, cpu.maxclockspeed0 from v_R_system vrs inner join v_GS_Processor cpu on vrs.resourceid = cpu.resourceid where cpu.deviceid0 = 'CPU1'
Set nocount off select distinct VRS.Name0, ws.LastHWScan, VRS.User_Name0, CS.Model0, cp1.currentclockspeed0 as "Current Speed CPU1/MHz", cp1.maxclockspeed0 as "Max Speed CPU1/MHz", cp2.currentclockspeed0 as "Current Speed CPU2/MHz", cp2.maxclockspeed0 as "Max Speed CPU2/MHz", mem.totalphysicalmemory0 as "Total RAM", ds1.size0 as "C: Total/MB", ds1.freespace0 as "C: Free/MB", ds2.size0 as "D: Total/MB", ds2.freespace0 as "D: Free/MB"
from v_R_System VRS INNER JOIN v_GS_COMPUTER_SYSTEM CS on vrs.resourceid = cs.resourceid inner join v_GS_SYSTEM_ENCLOSURE senc on vrs.resourceid = senc.resourceid inner join v_GS_WORKSTATION_STATUS ws on vrs.resourceid = ws.resourceid left join #CPU1 cp1 on vrs.resourceid = cp1.resourceid left join #CPU2 cp2 on vrs.resourceid = cp2.resourceid inner join v_GS_X86_PC_Memory mem on vrs.resourceid = mem.resourceid inner join #CDisk ds1 on vrs.resourceid = ds1.resourceid left join #DDisk ds2 on vrs.resourceid = ds2.resourceid where senc.ChassisTypes0 in (8,9,10,12,14,21) order by VRS.Name0 Set nocount on
drop table #CDisk
drop table #DDisk
drop table #CPU1
drop table #CPU2 
|
|
|
|