Software and odbc collection - KiXtart.org - official site

You are not logged in. [Log In] KiXtart.org website » Forums » KiXtart » Basic Scripting » Software and odbc collection

Page 1 of 1

1

Topic Options

#39196 - 2003-04-14 04:20 PM Software and odbc collection
AzzerShaw AzzerShaw Seasoned Scripter Registered: 2003-02-20 Posts: 510 Loc: Cheltenham, England	Hi Guys and Galls Are you aware of any script which I can run which will collect information on all programs installed on a Pc and also collect there 16bit and 32bit odbc connections ? The Pcs on my network are NT4. I have tried to look through the scripts foroum and cannot find anything ( Am quite new to Kix, so dont really know where to start.....help!!! _________________________ If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it. - W.C Fields
Top

#39197 - 2003-04-14 04:22 PM Re: Software and odbc collection
Kdyer Kdyer KiX Supporter Registered: 2001-01-03 Posts: 6241 Loc: Tigard, OR	AzzerShaw, You ask Software and ODBC.. What are you needing, specifically? There should be a couple of script for ODBC Connections and there is one for the Helpdesk that captures software installed. Kent _________________________ Utilize these resources: UDFs (Full List) KiXtart FAQ & How to's
Top

#39198 - 2003-04-14 04:26 PM Re: Software and odbc collection
Kdyer Kdyer KiX Supporter Registered: 2001-01-03 Posts: 6241 Loc: Tigard, OR	AzzerShaw, VFPDATASOURCE() - Creates an ODBC Connection to Visual FoxPro My Computer Info - for Help Desk use These should be a good start. Kent _________________________ Utilize these resources: UDFs (Full List) KiXtart FAQ & How to's
Top

#39199 - 2003-04-14 04:33 PM Re: Software and odbc collection
AzzerShaw AzzerShaw Seasoned Scripter Registered: 2003-02-20 Posts: 510 Loc: Cheltenham, England	Basically I've just been handed this dodgy task to look at all software (various types) and the odbc connections of the Pc's in one of our departments. If I cant come up with a script, it looks like i will be doing this manually on 100 pcs Which I'd rather not !! There could be some applications which dont have Odbc connections and are stand alone but I need these also..... _________________________ If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it. - W.C Fields
Top

#39200 - 2003-04-14 04:58 PM Re: Software and odbc collection
AzzerShaw AzzerShaw Seasoned Scripter Registered: 2003-02-20 Posts: 510 Loc: Cheltenham, England	Hi - I've looked at the two links but am getting confused !! The one link says about creating an odbc connection, not getting information about it ? The help desk guide kix, only seems to find programs that are listed within the script, and there are all kinds of diffrent Programs. What i would ideally need would be it to pull off the applications that appear in the add/remove programs ? I know this is a longshot but im just thinking of my tired feet _________________________ If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it. - W.C Fields
Top

#39201 - 2003-04-14 05:00 PM Re: Software and odbc collection
Kdyer Kdyer KiX Supporter Registered: 2001-01-03 Posts: 6241 Loc: Tigard, OR	ODBC Connections - Do an ENUMKEY on: 'HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI' Software installed - Do an ENUMKEY on: 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths' HTH, Kent _________________________ Utilize these resources: UDFs (Full List) KiXtart FAQ & How to's
Top

#39202 - 2003-04-15 01:34 AM Re: Software and odbc collection
Jose Jose Seasoned Scripter Registered: 2001-04-04 Posts: 693 Loc: Buenos Aires - Argentina	AzzerShaw: There is no single way to make an inventory of stuff, speccially when the data is so crossed over. Paste this address http://www.geocities.com/jose_manuelvigil/Kix/Software.zip in your browser you can download a sample I have made to pick up different information installed. What I tried to accomplish here is to join diferents arrays from different functions (not build by me...NTDOC´s and others work) that would make a big array, then load it to a relational database with two tables, the one that has all the soft and the one that has the relation computer-soft. Like this: GetUninstallInfo() + OfficeVersions() + IEVer() + Oracle() = BigArray You could do the same but instead of Oracle() FE u can build an ODBC() function and treat the results as a software that would have its own id in the table. The sample works if u have ADODB installed, look at the registry HKEY_CLASSES_ROOT\ADODB.Command if not MDAC will install. You will also need Kixforms.dll to make the form work. Maybe is a little messy like my hair or look written by spanish Tarzan but can give u a different view where u could go. {edit} If u have problems with the connection string, change it localy. [ 15. April 2003, 06:54: Message edited by: jose3 ] _________________________ Life is fine.
Top

#39203 - 2003-04-15 05:42 AM Re: Software and odbc collection
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	software installed. hehee... 100 machines... it will be messy if looked directly from add/remove. _________________________ ! download KiXnet
Top

#39204 - 2003-04-15 10:12 AM Re: Software and odbc collection
AzzerShaw AzzerShaw Seasoned Scripter Registered: 2003-02-20 Posts: 510 Loc: Cheltenham, England	I always get the best jobs........ _________________________ If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it. - W.C Fields
Top

#39205 - 2003-04-15 06:48 PM Re: Software and odbc collection
Kdyer Kdyer KiX Supporter Registered: 2001-01-03 Posts: 6241 Loc: Tigard, OR	AzzerShaw, Does this mean that Jose's solution works? Kent _________________________ Utilize these resources: UDFs (Full List) KiXtart FAQ & How to's
Top

#39206 - 2003-04-15 06:51 PM Re: Software and odbc collection
Kdyer Kdyer KiX Supporter Registered: 2001-01-03 Posts: 6241 Loc: Tigard, OR	Jose, Made a change in your script: Changed from - code: $String="DRIVER={Microsoft Access Driver (.mdb)}; DBQ=..\Software.mdb" To be - code: $String="DRIVER={Microsoft Access Driver (.mdb)}; DBQ="+@SCRIPTDIR+"\Software.mdb" Thanks, Kent _________________________ Utilize these resources: UDFs (Full List) KiXtart FAQ & How to's
Top

#39207 - 2003-04-16 01:36 PM Re: Software and odbc collection
AzzerShaw AzzerShaw Seasoned Scripter Registered: 2003-02-20 Posts: 510 Loc: Cheltenham, England	I havent try to be honest.. I have had a few issuses with machines off the network and blue screening (oh happy days!!) So i have looked for each program individually and copied all there odbc.ini files back to my pc for me to note...nearly finished now, thanks anyway guys ( I will try your suggestions when I have a few minutes spare, thanks again Aaron _________________________ If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it. - W.C Fields
Top

#39208 - 2003-04-16 07:39 PM Re: Software and odbc collection
Anonymous Anonymous Unregistered	http://www.aida32.hu/ This is freeware and works great!!! It supports logging to ODBC also.
Top

#39209 - 2003-04-16 07:51 PM Re: Software and odbc collection
Kdyer Kdyer KiX Supporter Registered: 2001-01-03 Posts: 6241 Loc: Tigard, OR	This is very cool.. You can add in the computers into a list or subnet and then scan 'em in. Kent _________________________ Utilize these resources: UDFs (Full List) KiXtart FAQ & How to's
Top

#39210 - 2003-04-16 09:04 PM Re: Software and odbc collection
Jose Jose Seasoned Scripter Registered: 2001-04-04 Posts: 693 Loc: Buenos Aires - Argentina	Thakns for the data kdyer I will apply it in some more scripts I have. _________________________ Life is fine.
Top

#39211 - 2005-03-02 04:27 PM Re: Software and odbc collection
ClientMaster ClientMaster Fresh Scripter Registered: 2005-01-19 Posts: 46 Loc: Tokyo, Japan	_________________________ How can you know good, unless you experience bad.
Top

#39212 - 2005-03-02 04:58 PM Re: Software and odbc collection
Les Les KiX Master Registered: 2001-06-11 Posts: 12734 Loc: fortfrances.on.ca	KRAY, Is there any particular reason you dredged up this corpse without even a single word besides your sig? _________________________ 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 578 anonymous users online.

Newest Members

Sir_Barrington, batdk82, StuTheCoder, M_Moore, BeeEm
17886 Registered Users

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

click tracking