locked
added computers report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    yesterday i had 161 computers in All Systems connections today i gave 200. is there a report that can be ran that will show how many computers we added from yesterday to today.

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    Thursday, May 24, 2012 8:43 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    @ Mike... I had typed it in too but didn't hit enter. LOL

    Each record has a creation date. I think you can see that in V_R_System. If you do select * from v_R_System and look for the creation date you should find it. Alternatively if you specified a FSP there are reports built-in for when clients installed.

    John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

    Thursday, May 24, 2012 11:19 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    200 - 161 = 39

    Sorry, couldn't resist...

    Mike...

    Thursday, May 24, 2012 10:04 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    LOL... i ment what computers... Like computer name :)... i should have been more discriptive... but if you wouldnt have replied i would have never known why anyones replied to my post :)

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    Thursday, May 24, 2012 10:05 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    again that was so funny

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    Thursday, May 24, 2012 10:06 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    @ Mike... I had typed it in too but didn't hit enter. LOL

    Each record has a creation date. I think you can see that in V_R_System. If you do select * from v_R_System and look for the creation date you should find it. Alternatively if you specified a FSP there are reports built-in for when clients installed.

    John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

    Thursday, May 24, 2012 11:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Expanding on John's statement - the query you want to create a report using is:

    Select Name0, ResourceID from v_R_System where Creation_Date0 > DATEADD(DD,-1,GETDATE())

    You can modify the date you are looking for by using the following information table regarding SQL:  http://msdn.microsoft.com/en-us/library/ms186819.aspx.  It defines the values you need to put for the "datepart."  Remember to go negative if going historically.

    Hope this helps!

    Chris Beahm

    • Proposed as answer by John Marcum Friday, May 25, 2012 3:22 AM
    Thursday, May 24, 2012 11:45 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    so i run these queries in SQL management studio are from sonewhere in SCCM 2012? if in SCCM 2012 where?

    thanks

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    Friday, May 25, 2012 7:06 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    SQL Statements :)

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    Friday, May 25, 2012 7:10 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    so i run these queries in SQL management studio are from sonewhere in SCCM 2012? if in SCCM 2012 where?

    thanks

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    These are WMI queries, the format is called WQL, which is a derivitive of SQL.

    So you'd add these queries to a collection as a collection query.

    http://msdn.microsoft.com/en-us/library/windows/desktop/aa394606(v=vs.85).aspx

    Friday, May 25, 2012 7:55 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Or you could just add it as an actual Query...  There's a Query section in the Monitoring group.

    That might be better because then you can get the info on demand and it will always be fresh whereas a collection would need to be updated (manually or on a schedule) when you want the information.

    Mike...

    Friday, May 25, 2012 11:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    so i run these queries in SQL management studio are from sonewhere in SCCM 2012? if in SCCM 2012 where?

    thanks

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    These are WMI queries, the format is called WQL, which is a derivitive of SQL.

    So you'd add these queries to a collection as a collection query.

    http://msdn.microsoft.com/en-us/library/windows/desktop/aa394606(v=vs.85).aspx


    The query posted by Danny is not WQL, it's SQL.

    John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

    Friday, May 25, 2012 12:23 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Made the below query from the monitor folder and it shows Invalid View in the content area...

    Select Name0, ResourceID from v_R_System where Creation_Date0 > DATEADD(DD,-1,GETDATE())

    ideas?

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    Friday, May 25, 2012 1:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    If i run this from SQL Management Studio i get results.

    also same for this query:

    select * from v_R_System

    same invlid view if i run from monitoring Sections queries but runs from SQL Management studio

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    Friday, May 25, 2012 1:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    so i run these queries in SQL management studio are from sonewhere in SCCM 2012? if in SCCM 2012 where?

    thanks

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    These are WMI queries, the format is called WQL, which is a derivitive of SQL.

    So you'd add these queries to a collection as a collection query.

    http://msdn.microsoft.com/en-us/library/windows/desktop/aa394606(v=vs.85).aspx


    The query posted by Danny is not WQL, it's SQL.

    John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

    Well spotted ... indeed it is REPORT and SQL and not COLLECTION and WQL ... at least he knows what WQL is for now ;-)
    Friday, May 25, 2012 1:24 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    If i run this from SQL Management Studio i get results.

    also same for this query:

    select * from v_R_System

    same invlid view if i run from monitoring Sections queries but runs from SQL Management studio

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    Are you sure you are selecting the correct database?

    John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

    Friday, May 25, 2012 1:39 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    ok now this thread just got funny...

    thanks guys :)

    yall have a great weekend

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr

    Friday, May 25, 2012 6:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    ok now this thread just got funny...

    thanks guys :)

    yall have a great weekend

    Twitter: @dguilloryjr LinkedIn: http://www.linkedin.com/in/dannyjr Facebook: http://www.facebook.com/#!/dguilloryjr


    Did you get an answer buddy? Propose one as the answer :-)
    Tuesday, May 29, 2012 7:04 AM