The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
COURSE of the MONTH
15 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Server Profiling
Posted on 2011-03-18
What is the best way to profile a windows server to see stuff like open ports, running services, installed software, server apps, OS version, shares, ACL’s, password policies etc. Is there a free way of gleaning all this kind of information in a single/couple of report/reports? If so what FREE default windows tools can do this? If not does anyone have a template document of what data to collect when profiling a windows server?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
7
6
- +1
15 Comments
you can use NETSTAT to determin what ports are being used and what process is using them if you use the -ano switch.
Server OS version can get from SYSTEMINFO
SHAREENUM will give you a list of shares and their associated ACL's
Running RSOP.MSC or GPRESULT from a command line will give you the password policies.
.....I think that covers it all ;)
Server OS version can get from SYSTEMINFO
SHAREENUM will give you a list of shares and their associated ACL's
Running RSOP.MSC or GPRESULT from a command line will give you the password policies.
.....I think that covers it all ;)
Spiceworks can do a lot, not sure if it does it all though: http://www.spiceworks.com
Otherwise, browse through this page, there might be somethuiing there you like:
http://www.experts-exchange.com/Software/System_Utilities/Q_26748566.html?cid=748#a34841205
Otherwise, browse through this page, there might be somethuiing there you like:
http://www.experts-exchange.com/Software/System_Utilities/Q_26748566.html?cid=748#a34841205
belarc tool is good for installed software, server apps, OS version etc
for open ports you can run netstat command from cmd or download and run Tcpview.exe tool (just google it)
for open ports you can run netstat command from cmd or download and run Tcpview.exe tool (just google it)
Active 1 day ago
Is their no commands that can show services/installed software on the server?
NETSTAT and SYSTEMINFO work a treat
NETSTAT and SYSTEMINFO work a treat
Active 1 day ago
Thanks thats useful, was more after though software and versions installed on the server(s), i.e. sql server 2000, IIS 7, oracle 9 etc etc.
You could get it from the WMI database, see here for how: http://www.sepago.de/helge/2010/01/14/how-to-list-all-installed-applications-from-the-command-line/
Active 1 day ago
Is it typical for the wmic product command not to work on xp/vista workstations, just tried it as a test and get an error when running it even as local admin
Looks like a known issue, you should be using Windows XP SP2 or later
http://support.microsoft.com/kb/823442
Another possibility, do you use an Internet Proxy? If so can you turn it off, also try turning of the Windows Firewall.
http://support.microsoft.com/kb/823442
Another possibility, do you use an Internet Proxy? If so can you turn it off, also try turning of the Windows Firewall.
Active 1 day ago
I am using XP SP 3
yes do use proxy/firewall but domain policies restrict us being able to turn it off
yes do use proxy/firewall but domain policies restrict us being able to turn it off
Featured Post
This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
Here's a look at newsworthy articles and community happenings during the last month.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller.
Log onto the new domain controller with a user account t…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Suggested Courses
Course of the Month15 days, 7 hours left to enroll
741 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.