Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Make a 100+ Server Inventory in 30 minutes Expand / Collapse
Author
Message
Posted Wednesday, June 9, 2010 10:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:33 PM
Points: 22, Visits: 297
Comments posted to this topic are about the item Make a 100+ Server Inventory in 30 minutes
Post #935120
Posted Wednesday, June 9, 2010 11:32 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:11 AM
Points: 230, Visits: 505
This is a good tool for systeminfo . Do you have a tool to capture sql server information like edition,service pack, cpu affinity mask, memory configured. Now these are caried out with scripts or system stored procedures

Thanks

Srinivas
Post #935161
Posted Thursday, June 10, 2010 12:05 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 4:02 AM
Points: 488, Visits: 1,340
Hi Stanley,

Good and informative article. Does it require any ports to be opened?



Regards,
Raj

Strictlysql.blogspot.com
Post #935167
Posted Thursday, June 10, 2010 12:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 28, 2013 3:17 AM
Points: 29, Visits: 191
Good Article. Thanks for sharing it.
I have used systeminfo in past, but generating a CSV with help of flags is an excellent idea. Makes to my personal command repo.


_____________
Vikas S. Rajput
Post #935178
Posted Thursday, June 10, 2010 12:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:33 PM
Points: 22, Visits: 297
Hi Srinivas,

For SQL Server, I think it have to do it with scripts and stored procs.

Stanley
Post #935179
Posted Thursday, June 10, 2010 1:04 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 18, 2012 1:22 AM
Points: 325, Visits: 234
Hi Stanley,

I am a DBA and this will surely make my life easy. thanks a lot for sharing this information.
Post #935188
Posted Thursday, June 10, 2010 1:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 6, 2014 3:56 AM
Points: 21, Visits: 118
Great info - quick and easy asset overview.
However - if you want to know stuff about what runs on server, try sydi server - it takes you just that step further - but also creates quite a lot more output that you might not need.

[url=http://sydiproject.com/products/sydi-server/][/url]

PS: It's free :) (and I am not associated in any way, just blown away by the usability of that little tool)



Post #935189
Posted Thursday, June 10, 2010 1:06 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 18, 2012 1:22 AM
Points: 325, Visits: 234
Hi Srinivas,

I am not sure if this will be of any help. but you can check this article of mine.

http://www.sqlservercentral.com/articles/Automating+SQL+Server+Health+Checks/68910/
Post #935191
Posted Thursday, June 10, 2010 1:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:33 PM
Points: 22, Visits: 297
Hi Raj,

Sorry I don't have idea of which port it is using.
So far I don't encounter any problem as long as I have enough permission to access the machine.

Stanley
Post #935192
Posted Thursday, June 10, 2010 1:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:33 PM
Points: 22, Visits: 297
Thanks Rajput.

There are much more commands you can return the result in remote machine, in CSV/List/Table format in the same way like tasklist, schtasks.
Post #935195
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse