September 2008 - Posts
The easiest way is to change the SMS_ to V_ and look around in the SQL Database. Lots of great articles about that on myitforum.
How about a query to match on partial table names:
Select correct database. Usually SMS_<SiteCode>
SELECT * FROM sysobjects WHERE name LIKE '%Compliance%' and xtype in ('U', 'V')
What is xtype?
- C = CHECK constraint
- D = Default or DEFAULT constraint
- F = FOREIGN KEY constraint
- L = Log
- P = Stored procedure
- PK = PRIMARY KEY constraint (type is K)
- RF = Replication filter stored procedure
- S = System table
- TR = Trigger
- U = User table
- UQ = UNIQUE constraint (type is K)
- V = View
- X = Extended stored procedure
One last thing to try. There is a table in SMS 2.0, SMS 2003 and ConfigMgr that displays collection queries in both WQL (what you see in the console) and SQL.
SELECT CollectionID, QueryKey, WQL, SQL
FROM dbo.Collection_Rules_SQL
I was working with my LAB default reporting site the other day when it prompted me for my user credentials. Without paying attention I typed in my production credentials. It loaded up fine except the navigation window displays nothing.
Oh good, security is working as desired. Now I just need to log out and change my credentials. Hang on there is no logout or switch credentials. How annoying.
Well, I have 30 other windows open. I don’t want to close Internet explorer.
1) Delete all cookies.
a. No Joy
2) Delete Files
a. No Joy
3) Clear History
a. No Joy
Come on this cant be that impossible. Searching Google… nada.
The only consistent way I found to change the ID was to close and reopen IE.
Anyone have any suggestions?
I was just trying to calculate the number of calories in a bag of Pop-Secret 94% fat free popcorn (the numbers don't match), when I noticed three changes on the ingredients list:
Ingredients
Whole Grain Popcorn, Salt, Fractionated Palm Oil, Natural and Artificial Flavor, Color Added, Nonfat Milk. Freshness Preserved By TBHQ.
1) "Whole Grain" Popcorn
That got me laughing and everyone I showed it to at work chuckled. For the record, a corn kernel for popping is the whole kernel. Always has been always will be (unless you buy pre-popped).
2) Change Partially Hydrogenated Soybean Oil (Adds A Trivial Amount of Trans Fat to Fractionated Palm Oil.
Note: - FDA says any amount non naturally occurring trans fat is bad
What is Fractionate Palm Oil?
Fractionation is a further phase of palm oil processing, designed to extract and concentrate specific fatty acid fractions. Fractionated palm oil, as found in food products, has a higher concentration of saturated fat than regular palm oil and is used for the convenience of manufacturers who like its stability and melting characteristics. The healthful aspects of natural palm oil are largely lost in the process. I've noticed that fractionated palm oil is a common ingredient in many power bars sold in health-food stores. - Andrew Weil, M.D
3) Freshness Preserved by Propyl Gallate to TBHQ
What is TBHQ?
This change was made because of the change from Trans Fat to Saturate Fat. TBHQ preserves saturated fat.
http://en.wikipedia.org/wiki/Tert-Butylhydroquinone
Summary: the box is saying Whole Grain to make it sound healthier, then removed Trans Fat and replaced it with Saturated Fat which also required a fat preservative change.
Nice, and delicious.
FTW: the box says 130 calories popped, but if you do the maths it calculates out to 120 calories popped per bag.
I am going to propose a terminology change. For endless years we called a workstation any machine with a single CPU. The growth of multiple core CPUs have changed this game.
Old
- Single CPU
- Dual CPU or 2way
- Quad CPU or 4way
Current
- Dual Core, Quad Core, Core2, 8 core, etc
- Dual CPU or 2way
- Quad CPU or 4way
Proposed
- Dual Corse, Quad Core, Core2, 8 core, etc
- 2 socket
- 4 socket
Using the socket nomenclature, there is no doubt you are talking about a mother board with the ability to utilize multiple physical CPU’s with an unknown number of cores.
Simple changes make easy explanations.
In windows x86 XP and Vista the System Center Configuration Manager 2007 client installs to the same location as the SMS 2003 client:
C:\WINDOWS\system32\CCM
Note: if you have a Windows 2000 upgraded box the directory would be:
C:\WINNT\system32\CCM Where is the x64 XP ConfigMgr Client?
During the install the ccmsetup directory is created at:
C:\WINDOWS\CCMSetup
And installed to:
C:\WINDOWS\SysWOW64\CCM
The installer is now available at www.google.com/chrome
This only works on Windows Vista and XP.
Installer is 457k. The installed package is 46.57MB
Interesting it installs to: C:\%\Profiles\USERNAME\Local Settings\Application Data\Google\Chrome\ So it does not require admin rights to install. This is not a good thing for a locked down corporate environment.
Key features of this product is true multithreaded processing in isolation in layers of each tab. New Java complier and engine that is multithreaded. Security that is far more robust.
Interesting. I'll post more when I play further.