IIS and SQL - KiXtart.org - official site

You are not logged in. [Log In] KiXtart.org website » Forums » KiXtart » Basic Scripting » IIS and SQL

Page 1 of 1

1

Topic Options

#140839 - 2005-06-02 03:34 PM IIS and SQL
JohnQ JohnQ Starting to like KiXtart Registered: 2003-03-04 Posts: 171	Does anyone know of way to determine if IIS or SQL is installed on any given server and if so, how to determine the version and service pack? I can find some of the info in the registry but not all of it.
Top

#140840 - 2005-06-02 04:38 PM Re: IIS and SQL
Les Les KiX Master Registered: 2001-06-11 Posts: 12734 Loc: fortfrances.on.ca	Port scans would reveal that. Now, if they use non-standard ports, it would be a little more challenging. _________________________ Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.
Top

#140841 - 2005-06-02 08:48 PM Re: IIS and SQL
JohnQ JohnQ Starting to like KiXtart Registered: 2003-03-04 Posts: 171	There's got to be a better way.
Top

#140842 - 2005-06-02 09:12 PM Re: IIS and SQL
NTDOC NTDOC Administrator Registered: 2000-07-28 Posts: 11631 Loc: CA	What is so difficult about using a scanner? Especially a free one. http://www.gfi.com/lannetscan/ There is also this utility along with many other command-line tools. NETVIEW Network View v1.20 (NetView.exe) Last Updated: 08/16/2001 Displays a list of all machines visible in the specified domain, based on role. Basically a command-line view of Network Neighborhood, similar to 'Net.exe View' but with the ability to filter on certain types of machines (workstations only, servers only, time servers, SQL servers, etc.). Use 'NetView /?' to view the syntax. NOTE: This list of machines is not real-time, but compiled and shared between network segments at 12 minute intervals. New machines will not appear in the browse list immediately, it may take up to 48 minutes, depending on the complexity of your network. Likewise, machines removed from the network are not immediately removed from the browse list, it may take up to 72 minutes. For more information, see Microsoft Knowledge Base articles 188001, 102878 and 150800. OptimumX HomePage Download Network View 1.2
Top

#140843 - 2005-06-02 09:30 PM Re: IIS and SQL
Les Les KiX Master Registered: 2001-06-11 Posts: 12734 Loc: fortfrances.on.ca	Version info you should be able to pull from the reg. _________________________ Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.
Top

#140844 - 2005-06-02 11:45 PM Re: IIS and SQL
NTDOC NTDOC Administrator Registered: 2000-07-28 Posts: 11631 Loc: CA	From that utility NETVIEW /SQL Shows a list of all systems with SQL Then as Les says, you can read the registry for much of the information, or grab an install location from the registry and run a GetFileVersion on it.
Top

#140845 - 2005-06-03 12:50 AM Re: IIS and SQL
JohnQ JohnQ Starting to like KiXtart Registered: 2003-03-04 Posts: 171	Thanks Doc. I was really looking for a way of determing the info via an existing inventory script that runs locally at startup. I guess I could check for the services and then go from there. I just thought maybe someone else had already had the same need. It's tought to keep up with 2,000+ servers and which ones are running what.
Top

#140846 - 2005-06-03 01:07 AM Re: IIS and SQL
NTDOC NTDOC Administrator Registered: 2000-07-28 Posts: 11631 Loc: CA	You can take a look at this script. Not sure it does what you want, but does a LOT My Computer Info - for Help Desk use PART 4
Top

#140847 - 2005-06-03 01:45 AM Re: IIS and SQL
JohnQ JohnQ Starting to like KiXtart Registered: 2003-03-04 Posts: 171	I already have my main inventory script. I just need to add the ability to detect SQL, IIS and Exchange along with versions and SP's.
Top

#140848 - 2005-06-04 02:40 PM Re: IIS and SQL
Sealeopard Sealeopard KiX Master Registered: 2001-04-25 Posts: 11165 Loc: Boston, MA, USA	Then go pull that info from the registry. _________________________ There are two types of vessels, submarines and targets.
Top

#140849 - 2005-06-06 03:32 PM Re: IIS and SQL
JohnQ JohnQ Starting to like KiXtart Registered: 2003-03-04 Posts: 171	The only problem with that is on the servers that I've spot checked, the version of SQL that I found in the registry does not match up exactly with what is returned if you execute Code: select @@version from query analyzer.
Top

#140850 - 2005-06-06 04:11 PM Re: IIS and SQL
Les Les KiX Master Registered: 2001-06-11 Posts: 12734 Loc: fortfrances.on.ca	What does the product or file version give you? _________________________ Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.
Top

Page 1 of 1

1

Previous Topic

Previous Topic View All Topics

View All Topics

Index Next Topic

Next Topic

Moderator: Jochen, Allen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Arend_, Mart

Hop to:

Shout Box

Who's Online

0 registered and 764 anonymous users online.

Newest Members

ManuvdWielNL, Sir_Barrington, batdk82, StuTheCoder, M_Moore
17887 Registered Users

Generated in 0.063 seconds in which 0.027 seconds were spent on a total of 12 queries. Zlib compression enabled.

click tracking