Product Versions
Jump to navigation
Jump to search
This page is designed to help determine product versions from the database side.
Works
SELECT * FROM Works..VersionNumber ORDER BY VersionNumber DESC
Note: this is a query from a v11 system. v10 systems wont have all these entries.
The version you are on will be the highest entry in the VersionNumber field- in this case v11.1.6.154.
Other important fields are...
- chMedcinSearch- tells the version of Medcin you are on. Medcin is delivered quarterly so you need to determine the quarter of your version by looking at the date (Q4 2008 in this example). If this doesn't match the release you believe to have, your Medcin Update SQL job most likely failed. Check its history in SQL Agent.
- AHSOCD- (v11 Only) this DB is part of the Allscripts delivered content and gets updated from time to time.
- CareGuide- (v11 Only) Indicates the version of CareGuide content that is currently in the system. This content is updated periodically. Newest content is delivered with new versions of v11 or can be updated in older v11 systems. If your Organization did not purchase CareGuides you will still have this DB, but you can ignore it.
Hot Fixes
IDXwf
SQL Version
Select * from IDXwf..Product
web server Version
Start >> Control Panel >> Add Remove Programs >> IDX Web Framework 4.0.XXXXXXXX
SQL Server
What_version_of_SQL_do_I_have?
Scan
Scan Server: [SCAN-INSTALL-DIRECTORY]\Server\ServicePack open ServicePackInfo.ini with notepad
[ServicePackInfo] Major=3 Minor=31 ServicePackID=XX ServicePackDate=XX/XX/20XX