Make a 100+ Server Inventory in 30 minutes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stanley Chan » Make a 100+ Server Inventory in 30 minutes

43 posts, Page 1 of 5

1 2 3 4 5 »»»

Make a 100+ Server Inventory in 30 minutes

Rate Topic

Display Mode

Topic Options

Author

Message

Stanley Chan

Posted Wednesday, June 09, 2010 10:21 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 31, 2013 7:02 AM
Points: 22, Visits: 280

Comments posted to this topic are about the item Make a 100+ Server Inventory in 30 minutes

Post #935120

M A Srinivas

Posted Wednesday, June 09, 2010 11:32 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:19 AM
Points: 228, Visits: 472

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

arr.nagaraj

Posted Thursday, June 10, 2010 12:05 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 12:27 AM
Points: 483, Visits: 1,191

Hi Stanley,

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

Regards,
Raj

Strictlysql.blogspot.com

Post #935167

Vikas S. Rajput

Posted Thursday, June 10, 2010 12:44 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, April 11, 2013 12:03 PM
Points: 29, Visits: 188

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. Smile

_____________
Vikas S. Rajput

Post #935178

Stanley Chan

Posted Thursday, June 10, 2010 12:49 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 31, 2013 7:02 AM
Points: 22, Visits: 280

Hi Srinivas,

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

Stanley

Post #935179

Ritesh Medhe

Posted Thursday, June 10, 2010 1:04 AM

Old 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

ryberg_b

Posted Thursday, June 10, 2010 1:04 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 3:07 AM
Points: 21, Visits: 115

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

Ritesh Medhe

Posted Thursday, June 10, 2010 1:06 AM

Old 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

Stanley Chan

Posted Thursday, June 10, 2010 1:16 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 31, 2013 7:02 AM
Points: 22, Visits: 280

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

Stanley Chan

Posted Thursday, June 10, 2010 1:21 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 31, 2013 7:02 AM
Points: 22, Visits: 280

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 »

43 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions