Loading...
HomeMy WebLinkAbout20070405-Aspen Pitkin Tech Environment Aspen/Pitkin In order for CRG to best understand the technology environment, please fill out this form as complete as possible. Current Technology Infrastructure–Computer Hardware 1. 1.1. Summary of hardware devices currently in use Hardware Devices Number Notes Number of Mainframe/Mini Computers 0 Number of PC Based Servers 52 Actually 3 of these are UNIX Number of SAN 0 We would like to get a SAN Number of NAS 0 Number of Workstations 500 More or less Number of Network Printers 100 ? This is a total guess Number of Hubs Number of Switches Number of Routers Number of Firewalls 1 Other (Define) Telecom City of Aspen and Pitkin County -- Technology Environment V.1.2 1 Copyright © Civic Resource Group April 4, 2007 1.2. List of current hardware vendors Hardware Vendor(s) Notes Mainframe/Mini Computers PC Based Servers Dell, HP Mostly Dell Workstations Gateway, Dell Laptops Network Printers HP, Ricoh Switches Cisco? Routers Cisco Firewalls Check Point – Firewall 1 1.3. Other Computer Hardware Narrative/Notes Narrative/Notes Current Technology Infrastructure–Network Infrastructure and 2. Telecom 2.1. Current Local Area Network (LAN) LAN Element Description Type of Network Fiber network to main campus, some converged networks with VOIP via T1 Any VLAN Yes City of Aspen and Pitkin County -- Technology Environment V.1.2 2 Copyright © Civic Resource Group April 4, 2007 LAN Element Description Services ? Protocols TCP /IP Domains Aspenpitkin.org Other/Narrative 2.2. Current Cabling LAN Element Description Notes Cable Type Cat 5 Known cabling issues Any plans for upgrade Any wireless devices Not officially supported Other/Narrative 2.3. Current Wide Area Network (WAN) WAN Element Description Notes Type of Network and bandwidth Services Protocols Domains Other/Narrative City of Aspen and Pitkin County -- Technology Environment V.1.2 3 Copyright © Civic Resource Group April 4, 2007 2.4. Remote Locations Remote Location Description (Function, Connectivity, Users) Landfill Pitkin County Landfill, converged voice and data over Quest T1, ~ 13 users Basalt Police Dept Snowmass Village Police Dept 2.5. Remote Connectivity Solutions Remote Connectivity Number or Yes/No Number of Remote Users RAS VPN Yes – from home and for vendor access – probably close to 50 people have access – not very heavy traffic. Other 2.6. Brief Narrative of Remote Connectivity Solutions in Use Narrative/Notes SecurID – Ace Server 2.7. Network Security Security Component In Use (Check) Vendor Firewall Yes Check Point Physical security Yes Mostly locked closets for servers City of Aspen and Pitkin County -- Technology Environment V.1.2 4 Copyright © Civic Resource Group April 4, 2007 Security Component In Use (Check) Vendor Intrusion Detection Yes Aladdin – E-Safe Monitoring Yes Spiceworks Anti-Virus Detection Yes Sophos Software Use of Multiple DMZ No Other 2.8. Brief Narrative of Network Security Infrastructure Security Narrative 2.9. Known Security Issues Security Issues Password sharing City of Aspen and Pitkin County -- Technology Environment V.1.2 5 Copyright © Civic Resource Group April 4, 2007 2.10. IT Emergency/Disaster Recovery Planning—Notes IT Emergency/Disaster Recovery Notes/Narrative Plan under way – nightly backups in place 2.11. Telecom System and ISP Item In Use (Check) Vendor Telecom PBX/Phone System V-IP IVR Other 2.12. Brief Narrative of Telecom System and ISP Narrative 2.13. List of IT/Web/Networking Service Vendors and Contracts (e.g. outsourced firewall, help desk, web support, etc.) Outsourced Item Description Web hosting and coding All web site development – Biz Net Technologies City of Aspen and Pitkin County -- Technology Environment V.1.2 6 Copyright © Civic Resource Group April 4, 2007 Outsourced Item Description 2.14. Other Known IT Issues (e.g., notes on poor service providers, recent changes in vendors, compatibility/integration problems, stability/at risk areas, future business/operational plans, etc.) Issue Description Current Technology Infrastructure – Operating Systems, 3. Software and Applications 3.1. What operating system(s) are currently used and how many licenses are available? Operating System No. of Number of Licenses Service Pack Computers/Servers Windows 2003 Server 49 Windows XP 353 SP2 Windows 2000 Server 1 Windows 2000 Professional 149 Windows NT Server 4.0 Windows NT Workstation 4.0 Windows Me, 98 or 95 City of Aspen and Pitkin County -- Technology Environment V.1.2 7 Copyright © Civic Resource Group April 4, 2007 Operating System No. of Number of Licenses Service Pack Computers/Servers Apple/Mac 0 Solaris/UNIX variants 3 Linux AS/400 Novell NetWare Other 3.2. Mail Server and Notes Mail Server and Other Communications Management Systems Exchange Server 3.3. IT Standards—Desktop Productivity Tools Item Vendor/Product Name Description (Number of end users licenses) Business Software (e.g. MS Office Microsoft Office) E-mail Client Outlook 2003 Web Browser IE 6 or Firefox Other (specify) City of Aspen and Pitkin County -- Technology Environment V.1.2 8 Copyright © Civic Resource Group April 4, 2007 3.4. What Reporting Tools (if any) are used (e.g. Crystal Reports, Cognos, MS Reporting Services)? Reporting Tools Underlying Database/Application Crystal Reports Oracle, SQL server 3.5. Is a data warehouse or other informational databases available? Database Application/Function NO 3.6. Major Line of Business Applications, including Vendor information. Area Application (Version) Vendor Financial System Inforum Gold v 2.2 Tyler Technologies – Eden Systems HR System Same Database Servers SQL Server, Oracle, Informix (DBMS) GIS System ESRI CAD Imaging/Document Clerk and Recorder, City Clerk, LaserFiche Management City of Aspen and Pitkin County -- Technology Environment V.1.2 9 Copyright © Civic Resource Group April 4, 2007 Area Application (Version) Vendor Business Licenses In the process of changing from one off system Eden Systems by Eden, to Incode Permitting/Land Inforum Gold Tyler Technologies – Management Eden Systems Building and Safety same Asset Mgmt./Tracking None Parks and Recreation Rectrac Vermont Systems Utility Billing Munis Tyler Technologies – Munis Other (specify) 3.7. List of Other Departmental/Business Applications Area/Dept. Application (Version) Vendor 3.8. List of In-house/Custom Applications Application Description We try to stay away from these. City of Aspen and Pitkin County -- Technology Environment V.1.2 10 Copyright © Civic Resource Group April 4, 2007 3.9. Hosting Environment Item Description Where is your hosting Offsite – Virginia data center environment? If offsite, please specify. Please specify web/application Cold Fusion, SQL Server, HTML server software in use. Is current website using RSS No technology to share content with other sites? What is current hosting DS3 and OC3 connections bandwidth speed? If the website has search It does. I think the software is written by our vendor function specify search software in use. 3.10. Website Analysis Description rd What Application or 3 party http://stats.webcreate.com/Aspen/aspen_main WebStats service is used for website analysis 21,000 – 25,000 Number of unique visitors List most frequent browsers used 80.44% - IE by visitors 13.89% - Netscape 1 No Referrer57,223 List website referring domains 2 http://www.google.com/9,299 3 http://www.aspenpitkin.com/7,487 4 http://www.orlando-guide.info/ 1,631 5 http://search.yahoo.com/1,323 6 http://city.aspenpitkin.com/1,311 7 http://search.msn.com/ 1 Google13,96981.87% List most referred search engines 2 Yahoo1,71210.03% 3 Microsoft Network1,2887.54% City of Aspen and Pitkin County -- Technology Environment V.1.2 11 Copyright © Civic Resource Group April 4, 2007 1 aspen colorado9675.66% List frequent user search Phrases 2 pitkin county8084.73% 3 city of aspen6994.09% 4 aspen6864.02% 5 pitkin county colorado2971.74% 6 aspen, colorado2201.28% City of Aspen and Pitkin County -- Technology Environment V.1.2 12 Copyright © Civic Resource Group April 4, 2007 3.11. Database Servers and Notes Database Server Oracle 10g – Assessor, Treasurer, Clerk and Recorder MS SQL Server 2000 – Doc. Imaging, Finance, HR, Permits, MS SQL Server 2005 – Public Safety, GIS Informix – Utility Billing 3.12. Web Development Tools (e.g. Dreamweaver, Frontpage). Tools Use/Description Homesite Web site maintenance 3.13. Web Application Development skills/standard (e.g. J2EE, ASP, .NET, PHP) Skills/standard Notes None in house We do basic updates using Macromedia Homesite 3.14. Current Web Publishing Process (including any content management software used, content creation process, frequency of updates, etc.) Web Publishing Component Process Description/Notes Updates / new content Published on request by the departments City of Aspen and Pitkin County -- Technology Environment V.1.2 13 Copyright © Civic Resource Group April 4, 2007 Web Publishing Component Process Description/Notes 3.15. E-Business/E-Commerce Applications and Processes E-Business Application Process Description/Notes On-line Utility Bill Payment 3.16. Intranet Use Description of Intranet and Intranet Tools Minimally used – information is left up to the departments – a variety of tools are used – Homesite, FrontPage, Dreamweaver IT Resources, Training and Support 4. 4.1. IT’s Annual Budget (including capital expenditures for new equipment) IT Budget Information City of Aspen and Pitkin County -- Technology Environment V.1.2 14 Copyright © Civic Resource Group April 4, 2007 4.2. PC Replacement/Upgrade Policy. PC Upgrade Policy City – get 1/5 of PC replacement budget every year – the actual replacement is flexible as far as timing. County – specific PC’s get replaced every 4 years We don’t typically upgrade PC OS software unless specifically requested. 4.3. IT Staff IT Staff—Specify Position/Level Primary Roles Full Time Part Time IT Director The boss F Network Application Specialist Major application F support Network Manager Network Coordinator Help Desk/User Support Percentage Support Ratio Users to IT support staff 4.4. Use of outside contractors for IT services for specific tasks/functions. Contract/Outsourced IT Staff Resources Wiring / Cabling City of Aspen and Pitkin County -- Technology Environment V.1.2 15 Copyright © Civic Resource Group April 4, 2007 4.5. Support/Help Desk System (e.g. software used to track help desk incidents, response time policy, resources deployed) Support/Help Desk Notes/Narrative ESP from CustomerSoft (most everyone hates it) 4.6. Internal End User Training System. Internal End-user Training There is an initial user orientation, then ongoing training for phone usage and Outlook. We also do ad- hoc training on things such as Excel, Adobe Writer, etc. 4.7. Major IT Project(s) Planned/Approved or Underway. List Planned/Approved Projects Public Safety – CAD, police records, jail, etc Clerk & Recorder – new recording system and e-recording Municipal Court – court docket and reporting Key: Green - Top 10 | Maroon - High | Teal - Medium | Blue - Low Updated 3/27/07 Define next generation network design and create RFP. Develop and implement a strategic training plan for staff and customers. Develop a project management methodology and get buy-in by City and County. Define a Disaster Recovery Plan by August 1st "Define requirements, explore options and implement centralized systems for network management to improve uptime." Reduce time overhead in five areas by at least 10%. Develop a well-defined plan for our next generation web site and make recommendations to decision makers. City of Aspen and Pitkin County -- Technology Environment V.1.2 16 Copyright © Civic Resource Group April 4, 2007 Coorinate implementation of approved projects with visual tracking tool Complete departmental Housecall program. Achieve consensus for full-featured Customer Support software by August 1st and make a plan for implementation. H - Eliminate all possible Unix remnants "H - ""New"" Public Safety New World system for CAD, Police Records, and Fire Records" Develop pre-conversion strategy for Spillman data and server replacement Evaluate Citrix Technology H - Establish combined City/County Customer Survey. "H - Password ""Hardening""" " Review, revise, & recommend identity management policies" H - Draft 2007 IS Workplan. Obtain TRC/Management buy-in for methodology and 2007 specifics. H - County-wide Wireless Project Issue RFI/C Award and get approval for contract H - Evaluate Storage/Backup options as part of Next Generation RFP. H - Adapt Unix workgroup servers to function without core network Unix services H - Convert Wheeler to network telephony using IP "H - ""New"" County Clerk and Recorder E-Recording application" "H - ""New"" City Finance Salestax application" "H - Use Best Year Yet to establish and track ""Top Ten Goals""" M - Work with GIS to expedite move to new array; utilize old disk drives to provide temporary relief for storage demand "M - ""Replacement"" Spillman Police Records system" M - Establish Windows base for Intranet services M - Complete Departmental Service Level Agreements and begin Departmental review process M - Acquire and install new Windows server for Spillman Police Records system M - OTM - TM Upgrade M - Upgrade Call Pilot M - Call Pilot Server upgrade M - Evaluate PC implementation scheduling M - Implement WebTrac - Recreation M - Upgrade AIMS to EagleAssessor M - Upgrade TIMS to EagleTreasurer M - Hercules Replacement M - Add Ice Garden to ring and test ring survivability M - Re-locate network equipment at Streets L - Evaluate automated configuration and imaging L - Replace Freedom Dictaphone L - Evaluate and Implement Integrity remote PC security config L - Work with County to pursue Airport Master Plan L - Negotiate SLA's with outside Public Safety entities for access to the network. L - Add North Forty Fire Station L - Evaluate bandwidth management L - Add centralized fax processing L - Evaluate Vista - new Windows OS L - Explore options for electronic signatures L - Add Zupancis L - Remove Service from downtown Fire station L - Re-configure Wheeler - currently implemented from Fire Station L - Repair Airport strands L - 1/3 of our batteries are scheduled for replacement NEW as of 2007 City Hall generator Obtain preliminary approvals Issue RFP Complete City Finance remodel Council Chambers and Sister Cities network and AV remodel Municipal Court - replace existing (new - FullCourt) ZGreen Web Application Wheeler cable audit City of Aspen and Pitkin County -- Technology Environment V.1.2 17 Copyright © Civic Resource Group April 4, 2007 Senior Center Remodel Senior Center closet cooling solution City Hall UPS monitoring solution City Hall 2nd AC unit power and ATR installation HHS Remodel Re-establish Smartphone support policy GIS - Info Cubed H - Streets fiber exposure City of Aspen and Pitkin County -- Technology Environment V.1.2 18 Copyright © Civic Resource Group April 4, 2007