Sounds like you need to do it again. below is a link. What happened before you tried going into SSCM? This might help us to identify your issue.

http://msmvps.com/blogs/martinpoon/archive/2009/11/27/sql-server-configuration-manager-cannot-connect-to-wmi-provider-invalid-class-0x80041010.aspx

???

That got it, I had to do some working around on it but I got what I was looking for. Thank you for putting me in the right direction. Next...

This converted the date but now I need to count...

SELECT

CONVERT(VARCHAR(10), UTCOccurrenceDateTime, 111)

FROM Alerts

WHERE (Heading LIKE 'Disk %') AND...

I get an error on the CAST;

select ServerName, Heading, UTCOccurrenceDateTime

REPLACE(CAST(UTCOccurrenceDateTime as date),'-','/')

from dbo.Alerts where Heading like '%blocking%'

AND DATEADD(hh, -6, UTCOccurrenceDateTime) >= DATEADD(day, DATEDIFF(day, 0, GETUTCDATE()), 0)

order by UTCOccurrenceDateTime

SELECT COUNT(*) AS Total,

COUNT(DISTINCT datakey) AS Uniquedatakey,

COUNT(DISTINCT CASE WHEN landline<>'' THEN landline END) AS Uniquelandline, ...

Yes, I am trying to conver the UTC time to Central time and count servername and UTCOccurrances so I can take the query from 50000 rows to once sername per...

Try this to start, I found this on another web site. I googled count figures in sql table.

http://www.w3schools.com/sql/sql_func_round.asp

SELECT DataKey, ROUND(DataKey,0) as DataKey FROM Tablename

I know your not inserting columns, :), After you insert you data into the table you are wanting to count the datakey column, if so then your select stmt would...

I am a little confused, are you inserting records then wanting to do a count on the table on certain columns?

I can open the db, query, everything seems normal, just have never see this and wanted to put it out there in case it was serious. Thanks for looking at...

got it, attached.

try to attach, not sure how to get an attachment on here.

Thanks guys I got all of figured out, now just putting it into SSRS, whuho!! 🙂

Yeah that did it, now back to the other query and trying to get it to count by Occurance, ServerName.

Thanks so much!

lk