<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.technet.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Some Interesting FCS SQL Queries</title><link>http://blogs.technet.com/b/kfalde/archive/2009/05/08/some-interesting-fcs-sql-queries.aspx</link><description>With a recent case I have an issue where the client count of managed computers in MOM admin console was quite different then that in the FCS console so I was trying to find out exactly which computers were not in FCS so I could troubleshoot some of those</description><dc:language>en-US</dc:language><generator>Telligent Evolution Platform Developer Build (Build: 5.6.50428.7875)</generator><item><title>re: Some Interesting FCS SQL Queries</title><link>http://blogs.technet.com/b/kfalde/archive/2009/05/08/some-interesting-fcs-sql-queries.aspx#3337432</link><pubDate>Thu, 10 Jun 2010 19:01:58 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3337432</guid><dc:creator>Cory</dc:creator><description>&lt;p&gt;The morning AV signature query is a god send. but for the life of me i cannot add &amp;quot;LastModified.Attribute&amp;quot; (or from a different table) added to the select query. &amp;nbsp;Any ideas?&lt;/p&gt;
&lt;p&gt;thanks&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.technet.com/aggbug.aspx?PostID=3337432" width="1" height="1"&gt;</description></item><item><title>re: Some Interesting FCS SQL Queries</title><link>http://blogs.technet.com/b/kfalde/archive/2009/05/08/some-interesting-fcs-sql-queries.aspx#3280627</link><pubDate>Fri, 11 Sep 2009 21:54:57 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3280627</guid><dc:creator>Troy</dc:creator><description>&lt;p&gt;Cool stuff. &amp;nbsp;Quick question for you - any chance you know how to run a query that would show what version of the av definition a particular computer has? &amp;nbsp;There are certain servers I need to check on every week but I can't figure out where the av defintion information lives for each computer. &amp;nbsp; &amp;nbsp;Thought I'd ask.&lt;/p&gt;
&lt;p&gt;thanks&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.technet.com/aggbug.aspx?PostID=3280627" width="1" height="1"&gt;</description></item><item><title>re: Some Interesting FCS SQL Queries</title><link>http://blogs.technet.com/b/kfalde/archive/2009/05/08/some-interesting-fcs-sql-queries.aspx#3262857</link><pubDate>Sat, 11 Jul 2009 00:49:44 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3262857</guid><dc:creator>mom</dc:creator><description>&lt;p&gt;ok.. kewl. i dont really understand this stuff, but at least you dont forget me. i saw u mentioned me a couple times.&lt;/p&gt;
&lt;p&gt;:)&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.technet.com/aggbug.aspx?PostID=3262857" width="1" height="1"&gt;</description></item><item><title>Geek Nation  &amp;raquo; Blog Archive   &amp;raquo; Stuff n Things : Some Interesting FCS SQL Queries</title><link>http://blogs.technet.com/b/kfalde/archive/2009/05/08/some-interesting-fcs-sql-queries.aspx#3255983</link><pubDate>Wed, 17 Jun 2009 23:48:47 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3255983</guid><dc:creator>Geek Nation  &amp;raquo; Blog Archive   &amp;raquo; Stuff n Things : Some Interesting FCS SQL Queries</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://geeknation.uberjournal.com/2009/06/17/stuff-n-things-some-interesting-fcs-sql-queries/"&gt;http://geeknation.uberjournal.com/2009/06/17/stuff-n-things-some-interesting-fcs-sql-queries/&lt;/a&gt;&lt;/p&gt;
&lt;img src="http://blogs.technet.com/aggbug.aspx?PostID=3255983" width="1" height="1"&gt;</description></item></channel></rss>