|
|
May 2007 - Posts
-
It took 2 hours, 4 minutes and 8 second to return 524031 rows from a db with ~3500PCs and isqlw.exe consumed just under 560MB of RAM. Don’t try to run the “All programs for each PC within a collection” as a web report, it will not work!
  
|
-
During a resent discussion within the mailing list this request was posted.
“I need to run a report of all software installed for each computer in a specific collection (or an AD site..Whichever)… Similar to the “Summary of Installed Software in a Specific Collection” report that comes with SP2, but rather than a summary, I want each computer name listed, with all installed software for each computer”
The report in question would look something like this
COMPUTER1 App1
COMPUTER1 App2
COMPUTER1 App3
COMPUTER2 App1
COMPUTER2 App2
COMPUTER2 App3
The problem I have with this is: Based on the average number or items with in my test database, each PC would have 186 rows! This makes this report unusable! However management and auditor continue to ask for this type of report without knowing what it really means.
What they should be asking for is a high level count of all applications, then be able to drill down to a list of PCs with that application.
So what is your average number of rows per PC?
SELECT Count(v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) AS 'Count0'
into #avge
FROM v_GS_ADD_REMOVE_PROGRAMS v_GS_ADD_REMOVE_PROGRAMS, v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM
WHERE v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_ADD_REMOVE_PROGRAMS.ResourceID
GROUP BY v_GS_COMPUTER_SYSTEM.Name0
select avg(count0) from #avge
drop table #avge
BTW if really want to kill a few trees here is the query that will produce the huge report requested above.
SELECT v_GS_COMPUTER_SYSTEM.Name0,
v_GS_ADD_REMOVE_PROGRAMS.DisplayName0,
v_GS_ADD_REMOVE_PROGRAMS.ProdID0,
v_GS_ADD_REMOVE_PROGRAMS.Publisher0,
v_GS_ADD_REMOVE_PROGRAMS.InstallDate0
FROM
v_CM_RES_COLL_SMS00001 v_CM_RES_COLL_SMS00001,
v_GS_ADD_REMOVE_PROGRAMS v_GS_ADD_REMOVE_PROGRAMS,
v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM
WHERE
v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_ADD_REMOVE_PROGRAMS.ResourceID
AND v_GS_COMPUTER_SYSTEM.ResourceID = v_CM_RES_COLL_SMS00001.ResourceID
Order by
v_GS_COMPUTER_SYSTEM.Name0,
v_GS_ADD_REMOVE_PROGRAMS.ProdID0 
|
-
-
From an email to me:
What is MatchIT?
MatchIT is an online environment where charities and not-for-profit organizations can connect with Developers, IT Pro’s, Designers, Students or other technical individuals willing to volunteer their time and expertise to bring technology solutions to these organizations. Our goal is to enable them to be more effective with their limited resources and focus their efforts on having a positive impact in society.
What does MatchIT do?
MatchIT will allow charities across the country to post virtual "want ads" describing opportunities to our audiences that have inputted their volunteer profile to assist these organizations. Through a unique taxonomy process developed by our friends at Navantis, only true matches will be put forward to awaiting volunteers, so users will not have to wade through all the opportunities to find a good fit.
In addition to assisting in aligning these volunteer opportunities, Microsoft Canada Community Affairs will provide the applicable Microsoft software to the charities in order to ensure that the job is done right!
How can I get involved?
I already mentioned we need volunteers but also - help us spread the word! The more volunteers with technical skills we have ready for opportunities, the better as the need for technical assistance in the charitable sector is astounding. If you know a Developer or IT Pro looking for ways they can help Canadian communities, or if you are interested in applying your technical skills to incredible Canadian charities in a volunteer capacity, simply visit http://matchit.imaginecanada.ca/MSImagine/Home.aspx and "Sign Up"!
(note: the matchit.ca domain is in the process of coming online, so for the short-term please direct to http://matchit.imaginecanada.ca/MSImagine - long term it will be matchit.ca )
|
-
select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%.NET Framework 2.0%") and SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%.NET Framework 3.0%") order by SMS_G_System_SYSTEM.Name 
|
-
select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%.NET Framework 3.0%")order by SMS_G_System_SYSTEM.Name 
|
-
select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%.NET Framework 3.0%" order by SMS_G_System_COMPUTER_SYSTEM.Name 
|
-
select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%.NET Framework 2.0%" order by SMS_G_System_COMPUTER_SYSTEM.Name 
|
-
select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%.NET Framework 2.0%") order by SMS_G_System_SYSTEM.Name 
|
-
This will give you a count of collected files.
SELECT vCollectedFile.FileName, Count(vCollectedFile.FileName) AS 'Count'
FROM vCollectedFile vCollectedFile
GROUP BY vCollectedFile.FileName
ORDER BY vCollectedFile.FileName 
|
-
|
|
Clinic 2263: Exam Preparation for the MCDST Certification |
|
|
Summary: This online clinic prepares students who are currently providing end-user support in a Microsoft Windows® XP operating environment with a review of the objectives covered on the Microsoft Certified Desktop Support Technician (MCDST) certification exams.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 1 year |
|
|
|
|
Collection 5934: Introducing Microsoft Windows Server Code Name "Longhorn" (Beta 3) |
|
|
Summary: In this online collection composed of four clinics, you are introduced to the new features and functionality in Windows Server "Longhorn". This includes server virtualization, security and policy management, branch office management, centralized application access, and server management.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 90 days |
|
|
|
Clinic 2855: Managing Security Enhancements in Windows Server™ 2003 Service Pack 1 |
|
|
Summary: This online clinic will show systems administrators and system engineers how to implement, deploy, support, and configure Windows Server 2003 SP1 security enhancements. It will provide in-depth information on the security changes in SP1 over previous versions.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 180 days |
|
|
|
|
Clinic 4360: Getting Started with Microsoft® Windows Server™ 2003 R2 |
|
|
Summary: This clinic provides students you with an understanding of the features in Windows Server™ 2003 R2 including branch office considerations, Federated Identity Management, and storage management.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 90 days |
|
|
Clinic 2801: Microsoft® Security Guidance Training I |
|
|
Summary: This online clinic provides students with introductory knowledge and skills essential for the design and implementation of a secure computing environment. It also provides students with prescriptive guidance on security update management and best practices for implementing security on Microsoft Windows® server and client computers.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 180 days |
|
|
|
|
Clinic 2802: Microsoft® Security Guidance Training II |
|
|
Summary: This online clinic builds on existing knowledge of server and client security and provides students with the knowledge and skills to apply best practices to implement perimeter and network defenses and enhance security for applications and Microsoft® Windows Server System™ components. It also provides students with prescriptive guidance to enhance security for Microsoft Windows® server and client computers and practical strategies for implementing security for wireless networks.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 180 days |
|
|
|
|
Clinic 2803: Microsoft® Security Guidance Training III |
|
|
Summary: This online clinic builds on existing knowledge of server and client security and provides students with the knowledge and skills to apply security best practices for Microsoft® Exchange Server and to use Microsoft Internet Security and Acceleration (ISA) Server 2004 to improve security at the network perimeter. It also provides students with prescriptive guidance to implement layered defenses against malicious software and measures to increase security for Microsoft Windows NT® 4.0 and Windows® 98 network clients.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 180 days |
|
|
|
|
Clinic 2804: Microsoft® Security Guidance Training IV |
|
|
Summary: This online clinic provides students with prescriptive guidance that builds on their knowledge of security essentials to help them improve security for their infrastructures.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 180 days |
|
|
|
|
Clinic 2806: Microsoft® Security Guidance Training for Developers |
|
|
Summary: This online clinic provides students with knowledge and skills essential for the creation of applications with enhanced security. Students will learn about the need for implementing security at every stage of the development process and best practices for applying security principles. Students will also learn how to use established threat modeling methodologies and tools with other best practices to minimize vulnerabilities and limit damage from attacks. Finally, students will learn how to implement security features to enhance security for Web applications and Web services that are built by using Microsoft ASP.NET.
Audience: Developer
Available Offline: Yes
Price: FREE
Subscription: 180 days |
|
|
|
|
Clinic 2807: Microsoft® Security Guidance Training for Developers II |
|
|
Summary: This clinic discusses best practices for building security into the design, development, testing, and deployment phases of the software development life cycle. It is targeted towards individual with at least one to two years of programming experience. The course will provide developers with the skills and knowledge to design and develop more secure Microsoft solutions.
Audience: Developer
Available Offline: Yes
Price: FREE
Subscription: 180 days |
|
|
|
|
Clinic 2808: Microsoft® Security Guidance Training V |
|
|
Summary: This clinic builds on existing knowledge of server and client security and provides students with the knowledge and skills to apply best practices to securing Microsoft® Exchange Server clients, protecting e-mail and data content, securing services and critical accounts, and securing administrative accounts and remote access using smart cards.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 180 days |
|
|
|
|
Clinic 2855: Managing Security Enhancements in Windows Server™ 2003 Service Pack 1 |
|
|
Summary: This online clinic will show systems administrators and system engineers how to implement, deploy, support, and configure Windows Server 2003 SP1 security enhancements. It will provide in-depth information on the security changes in SP1 over previous versions.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 180 days |
|
|
|
|
Clinic 6078: Deploying Microsoft® Forefront™ Client Security |
|
|
Summary: This online clinic will provide the knowledge necessary to understand the key features of Microsoft Forefront Client Security, as well as the considerations for deploying Forefront Client Security in a network environment.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 90 days |
|
|
|
|
Clinic 6080: Deploying Microsoft® Forefront™ Server Security Products |
|
|
Summary: This online clinic will provide the knowledge necessary to understand the key features of Microsoft Forefront Server Security for Exchange, and Microsoft Forefront Server Security for SharePoint.
Audience: IT Pro
Available Offline: Yes
Price: FREE
Subscription: 90 days |
|
-
Thanks goes out to Dave Berry, who sent in this query.
SELECT
v_GS_COMPUTER_SYSTEM.Name0 as 'PC Name',
v_GS_SMS_ADVANCED_CLIENT_CACH.Location0,
v_GS_SMS_ADVANCED_CLIENT_CACH.Size0
FROM
v_GS_SMS_ADVANCED_CLIENT_CACH, v_GS_COMPUTER_SYSTEM
Where
v_GS_SMS_ADVANCED_CLIENT_CACH.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID
ORDER BY
v_GS_COMPUTER_SYSTEM.Name0 
|
-
-
What more do I need to say?
  
|
-
-
SELECT vSMS_AdvertisementInfo.AdvertisementID as 'Advert Id', vSMS_AdvertisementInfo.AdvertisementName as 'Advert Name', vSMS_AdvertisementInfo.ProgramName as 'Program', vSMS_AdvertisementInfo.PackageName as 'Pacakge', vSMS_AdvertisementInfo.CollectionName as 'Collection' FROM vSMS_AdvertisementInfo vSMS_AdvertisementInfo 
|
-
Here is yet another update from the newsgroup on SP3 Inventory causing 100% CPU issues
"I've noticed the same issue with the Browser Helper Object "bad download
blocker" - SDHelper.dll from Spybot Search and Destroy. The dll language
version is also multi-lingual (German and US English) and here in the UK it
sends the WMIPrvse service into a 100% deadlock."
|
-
Below is the summary of all PUBLIC Canadian MVP profiles created on www.microsoft.com/mvp.
All credit goes to Ljupco, for his tedious work on this one.
|
-
select Description0 as 'Description', Count (Description0) as 'Count' from v_GS_IDE_CONTROLLER Group by Description0 Order By Description0 
|
-
-
SELECT v_GS_COMPUTER_SYSTEM.Name0, SoftwareInventoryStatus.LastCollFileUpdateDate FROM SoftwareInventoryStatus SoftwareInventoryStatus, v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM WHERE v_GS_COMPUTER_SYSTEM.ResourceID = SoftwareInventoryStatus.ClientId 
|
-
SELECT v_GS_COMPUTER_SYSTEM.Name0, SoftwareInventoryStatus.LastUpdateDate FROM SoftwareInventoryStatus SoftwareInventoryStatus, v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM WHERE v_GS_COMPUTER_SYSTEM.ResourceID = SoftwareInventoryStatus.ClientId 
|
-
From the Newsgroup Microsft.public.sms.admin
We have identified this issue is caused by one bug in SMS_AutoStartSoftware
class. This new class added in SP3 collects auto run software information
from the clients. When you have some files in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run (or some
other auto run locacations), the file language is a mixed language, and also
the current user locale is different than the file language,
SMS_AutoStartSoftware class cannot handle that correctly. The result is it
went into a dead loop, and generated high CPU ulilization.
The workaround is: backup sms_def.mof under sms\inboxes\clifiles.src\hinv,
and then modify sms_def.mof to disable the SMS_AutoStartSoftware class.
Search SMS_AutoStartSoftware in sms_def.mof, you can find information as
below:
[ dynamic, provider("AAInstProv"),
SMS_Report (TRUE),
SMS_Group_Name ("AutoStart Software"),
SMS_Namespace (TRUE),
SMS_Class_ID ("MICROSOFT|AUTOSTART_SOFTWARE|1.0") ]
class SMS_AutoStartSoftware : SMS_Class_Template
Change " SMS_Report (TRUE)" to "SMS_Report (FALSE)", and save the
file.
This class only collects auto run software information. After disabling this
class, you can still get all license data.
|
-
1) Follow the KISS principal
2) Always use the views not the tables for your SQL queries
3) Keep report to a 4-5 columns
4) Try to limit the number of views used within each SQL query
5) Keep the drill through column as the first column
6) Try to link reports as: Count of ?, List of ?, Computer Details
7) For each item you add to your sms_def.mof add/create the corresponding web reports.
8) Backup your SQL queries!!!
9) Limit the use of v_R* views
10) Publish as many queries as possible
11) Grant access to all of your web reports to your IT team, particularly management! 
|
-
This blog post goes with the Subset Query post. This is the WQL example with a few tips.
- For the positive query don’t return the PC name because of the possibility of duplicate PC Names instead return ResourceID
- I also like to keep my queries clean of the junk that the SMS wizard-built queries have. I think that the run faster.
Below is what positive query would look like.
select distinct
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
from
SMS_G_System_ADD_REMOVE_PROGRAMS
where
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Visio 12"
Now the negative query
select distinct
SMS_G_System_COMPUTER_SYSTEM.Name
from
SMS_G_System_COMPUTER_SYSTEM
where
SMS_G_System_COMPUTER_SYSTEM.ResourceID not in (select distinct
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
from
SMS_G_System_ADD_REMOVE_PROGRAMS
where
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Visio 12")
Hopefully this gives you an insight on how to create and use subset queries.
|
-
Some ITMU-specific reports contain no data after you upgrade to SMS 2003 Service Pack 3. There are two very simple options you have to fix the problem. Read the article:
http://support.microsoft.com/kb/937098 
|
-
This blog post goes with the Subset Query post. This is the SQL example with a few tips.
- Doesn’t this look exactly like WQL Post? Yes it is supposed to look exactly alike, it is intended to show the same query so that it is easy to follow from one example to another.
- For the positive query don’t return the PC name because of the possibility of duplicate PC Names instead return ResourceID
- I also like to keep my query clean of the junk. I think that they run faster.
Below is what the positive query would look like.
SELECT
v_GS_ADD_REMOVE_PROGRAMS.ResourceID
FROM
v_GS_ADD_REMOVE_PROGRAMS v_GS_ADD_REMOVE_PROGRAMS
WHERE
v_GS_ADD_REMOVE_PROGRAMS.DisplayName0='Visio 12’
Now the negative query
Select
v_GS_COMPUTER_SYSTEM.Name0
from
v_GS_COMPUTER_SYSTEM
Where
v_GS_COMPUTER_SYSTEM.ResourceID not in ( SELECT
v_GS_ADD_REMOVE_PROGRAMS.ResourceID
FROM
v_GS_ADD_REMOVE_PROGRAMS v_GS_ADD_REMOVE_PROGRAMS
WHERE
v_GS_ADD_REMOVE_PROGRAMS.DisplayName0='Visio 12')
Hopefully this gives you an insight on how to create and use subset queries. 
|
-
A subset query is made up of two parts, first the positive query and then the negative query. This might seem dumb but in order to ensure that you get the results that you are looking for you need to exclude all PCs with the positive.
Let’s use the following table for all of our examples. This table is comprised of 4 PC add/remove programs (ARP).
|
PC1 |
PC2 |
PC3 |
PC4 |
|
SCCM client |
SCCM client |
SCCM client |
SMS 2k3 client |
|
Adobe Reader 7.1 |
MS Project 2k |
Visio 12 |
Adobe Reader 8.0 |
|
Visio 12 |
CorelDraw |
ITunes |
MS Project 2k |
|
ITunes |
Office XP |
WordStar |
DataStar |
|
Office 97 |
|
|
Lotus123 |
|
|
|
|
Kix 2010 |
Use a pseudo code if I write my query like this,
Find all PC where ARP not like “Visio 12”
A lot of people would expect to get PC2 and PC4 returned but that is not the case. Think about it. For PC1 is the first ARP line like “Visio 12”? No it is not therefore it would be added to result set. The same is also true for PC 4.
Now let look at the positive method, Use a pseudo code if I write my query like this,
Find all PC where ARP like “Visio 12”
In this case we would expect that PC1 and PC3 to be returned and you would be correct. So you ask but I want to know all PCs without “Visio 12” how do I do that?
This brings us to the negative and subset part of the query. We know all PCs that have “Visio 12” so now let find all that don’t. Use a pseudo code if I write my query like this,
Find all PC where PC is not in (Find all PC where ARP like “Visio 12”)
First this query will find all PCs with “Visio 12” then it will compare this to all PC and only display those PC which are not in the first query. Hence we get PC2 and PC4.
Now you are asking yourself what use is it to know the background of how I get what I want! What I need is some “real world examples” to play with.
Here are examples for:
WQL (tomorrow)
SQL (2 days from now) 
|
-
Well, there are actually two of them that I modify to use in my own web application. They are the Hardware 3A and Hardware 5A (both relating to Console Users) reports.
Report 3A (Primary Computer Users) is really cool, but one little gotcha is that there must be a primary user on the machine it is run against, with over 66% or the logon time, otherwise it reports back a NULL (i.e no one).
I think this is a generally a good number to use (and of course you can modify it to your own liking in the report), but on server systems, especially like Citrix boxes (in my environment), that just isn't going to happen. That's were Report 5A (Console Users on a Specific Computer) comes in handy, as it will list all users, and order them by their logon percentage.
One of the functions in my web application, is a search by "user/owner", so you can see why a combination of these two will give me exactly what I need in order to find exactly what you are looking for.
One little note to remember about all the reports relating to Console user/usage, is that the information is taken from the security logs for the "last 90 days". Just helps keep it all current. 
|
-
Use this query to get a count of installed client agents.
SELECT
v_GS_SMS_ADVANCED_CLIENT_STAT.DisplayName0 AS 'Component',
v_GS_SMS_ADVANCED_CLIENT_STAT.Version0 AS 'Version',
Count(v_GS_SMS_ADVANCED_CLIENT_STAT.Version0) AS 'Count'
FROM
v_GS_SMS_ADVANCED_CLIENT_STAT v_GS_SMS_ADVANCED_CLIENT_STAT
Where
v_GS_SMS_ADVANCED_CLIENT_STAT.DisplayName0='SMS Client Core Components'
GROUP BY
v_GS_SMS_ADVANCED_CLIENT_STAT.DisplayName0,
v_GS_SMS_ADVANCED_CLIENT_STAT.Version0
|
-
Use this SQL query to find all WS within an OU.
SELECT
v_RA_System_SystemOUName.System_OU_Name0,
v_R_System.Name0
FROM
v_R_System v_R_System,
v_RA_System_SystemOUName v_RA_System_SystemOUName
WHERE v_R_System.ResourceID = v_RA_System_SystemOUName.ResourceID
ORDER BY v_RA_System_SystemOUName.System_OU_Name0
and to populate views needed for this query you need to enable AD System
Group Discovery in addition to AD System Discovery.
|
-
-
This is another popular question. There is no right or wrong answer to this: the simple answer is “it depends”. The second question is “what does it depend on?”; well this is where questions like these are asked:
- How many sites do you have?
- What does your AD look like?
- How many advertisements will you have?
- ...( read more) 
|
-
Ok, so it turns out I did have a minor hiccup. No big deal as the help files sorted me out.
Having read the 3 help files and testing in the lab before taking the plunge in production, one biggie I made sure to note was the dcom permissions, as I know of many who have been affected by them in one way or another. Well, all looked ok, but today, I noticed that new machines were not getting the client installed via our gpo startup script. A quick check on the System event logs on my central site showed plenty of DCOM errors. Well I quickly checked in DCMCNFG, and yup, IUSR_servername was not listed anymore. Follwing the instructions quickly stopped the errors, and once again new clients started installing.
Problem solved: BTW, Here's the fix (right from the help file):
Server Locator Point Might Stop Functioning After Upgrading To SMS 2003 Service Pack 3
If the site system serving as your server locator point (SLP) is running Microsoft Windows Server 2003 SP1, the Local Launch permissions for the Internet Guest Account may be removed after the upgrade to SMS 2003 SP3.
WORKAROUND: Follow the manual procedures outlined in the Site Systems Frequently Asked Questions.
Reset the COM permissions so that the Internet Guest Account (IUSR_<servername>) has Local Launch permissions, as shown in the following procedure.
To grant Local Launch permission to the Internet Guest Account
On the site system, from the Start menu, click Run and type dcomcnfg.exe.
In Component Services, click Console Root, then click Component Services. Next, click Computers, My Computer, DCOM Config, and then click SMS_SERVER_LOCATOR POINT. On the Action menu, click Properties.
In the Launch and Activation Properties dialog box, navigate to the Security tab. In the Launch and Activation Permissions section, click Edit.
In the Launch and Activation Permissions dialog box, select the check box to allow Local Activation for Internet Guest Account (IUSR_servername). 
|
-
Top 25 posts
I was asked “How did you get a list of your top 25 posts?” the answer is that I wrote a query to determine this. Then I formatted the results in Excel and added the URLs for each post.
Here is the query that I used for my post/blog:
select top 25
totalviews + Aggviews as 'Total' ,
Subject as 'Title',
totalviews as 'Web views',
Aggviews as 'RSS Views'
--,postauthor as 'Author'
--,SEC.name as 'Blog Name'
from cs_Posts cs_Posts, cs_Sections SEC
where...( read more) 
|
-
I went and installed it on 5 production sites last night, and found it was hassle free. I had a bit of a worry when a few of my primaries sat there for 5 minutes thinking about shutting down services, but if there's one thing I have learned over all these years, it's patience.
Like every good admin knows when doing any upgrading, make sure you watch both the smssetup.log and mpsetup.log. The MP reinstall seems to start about 1 minute after SMS says it successfully did the update, and took about 3 minutes to complete.
Upgrading clients was a no brainier as well. Simply did the right-click/All Tasks/Install Client method, and happily watched the ccm.log run away. Of course I ended up with plenty of CCRs in the ccrretyr.box (this was after hours), so decided to delete them, and let my gpo startup script (for client health/install) look after those that weren't on the network at the time. I figured there was no sense in having the client reinstall try countless times over the evening after all.
One thing I did decide to do was to add my sms_def.mof customizations after the fact. I had a few new ones to add anyways, so I just created a new collection for all 2.50.4253.3000 clients, and ran the mofcomp with the new mof (its been added to the main one on each site as well).
|
-
Last night Ellen and I returned from a charity event, which Chris Mosby would have loved but that is another story, and we turned on the TV to watch the news before going to bed. Anyway one of the stories, more of a “teaser” than a story, was what are Canada’s 7 Wonders? So during the commercial break I started to come up with my list.
I have pre-posted my answers to this blog and they will show up at 5:00 a.m. EST on May 5, however what are your 7 Canadian Wonders?
Rules:
- Must be a place or thing (man made is allowed)
- Try not to look at CBC Web site.
- Pre-post your answers to show up at 5:00 a.m. EST to your blog
Examples:
I will provide two obvious answers (listed in no particular order):
- CN Tower
- Niagara falls
For my American and world blog readers, what are your local wonders? 
|
-
Yesterday I posted the top 25 for my Blog well today I will post the top 25 for the site. Hopefully I can overcome Community Servers incessant need to reformat Blog and remove what it believes’s are unneeded spaces.
|
-
Here are the top 25 post for my Blog, I did it out of interest only.
|
|
|
|