Now Available:

Featured Resources:

Newsletter

Email Address:

Subscribe





Ask the Expert

Have a question for our resident expert? .

Realtime Communities

« A technical look at the Security Configuration Wizard Part I | Main | Happy Patchless Tuesday Everyone! »

SMS Queries to SMS Reports: A Seven Part Series

I discovered this article today on MyITForum. It is one of the best collections I've seen of the process one needs to take to migrate an SMS Query to an SMS Report.

Read the series here:

If you've used SMS 2003, then you're familiar with the problem that building an SMS Query uses WQL, while SMS Reports use standard SQL. Converting between these two languages has its idiosyncrasies, and knowing how to do the conversion is critical for SMS administrators who need to provide reports (above the canned ones). The series is a great read.

TrackBack

TrackBack URL for this entry:
https://realtime-windowsserver.com/type/mt-tb.cgi/39

Most Active Posts

Recent Posts

Greg Shields' Bio:

Greg Shields is a Principal Consultant with 3t Systems in Denver, Colorado. With more than 10 years of experience in information technology, Greg has developed extensive experience in systems administration, engineering, and architecture specializing in Microsoft, Citrix, and VMware technologies. Greg is a Contributing Editor for both Redmond Magazine and Microsoft Certified Professional Magazine, authoring two regular columns along with numerous feature articles, webcasts, and white papers. He is known for his abilities to relate highly technical concepts with a drive towards fulfilling business needs. Greg is also a highly sought-after instructor and speaker, teaching system and network troubleshooting curriculum for TechMentor Events, a twice-annual IT conference, and producing computer-based training curriculum for CBT Nuggets on numerous topics. Greg is a triple Microsoft Certified Systems Engineer (MCSE) with security specialization and a Certified Citrix Enterprise Administrator (CCEA).