VB Script to Create a Scheduled Task on a Remote Machine Using Alternate Credentials
This is a small VB script I created to remotely schedule a task on another machine, using a different user account from the one logged in the local computer. It was needed because PsExec (a sysinternals’ tool we use a lot) didn’t always work well in some situations where we needed to execute remote tasks [...]
Answer Question
| October 21, 2011 11:36 PM
IT Scripts, MS Windows, Scheduled Tasks, VB script, WMI
This is a small VB script I created to remotely schedule a task on another machine, using a different user account from the one logged in the local computer. It was needed because PsExec (a sysinternals’ tool we use a lot) didn’t always work well in some situations where we needed to execute remote tasks [...]
Answer Question
| October 21, 2011 11:36 PM
IT Scripts, MS Windows, Scheduled Tasks, VB script, WMI
VB 2008.NET multi language program support
i am trying to find out how to code vb 2008 programs in foreign languages. and there seems to be little in the way of info on the subject any help pointing me in the right direction would be greatly appreciated.
Answer Question
| October 18, 2011 9:39 PM
.NET, VB 2008, Visual Basic 2008
i am trying to find out how to code vb 2008 programs in foreign languages. and there seems to be little in the way of info on the subject any help pointing me in the right direction would be greatly appreciated.
Answer Question
| October 18, 2011 9:39 PM
.NET, VB 2008, Visual Basic 2008
Free IT Book: Demystifying the Virtual Desktop
Interested in desktop virtualization? This week’s free IT book is just what you need. Michael Fox’s Demystifying the Virtual Desktop Starting with Desktop Virtualization is a quick read that breaks down the business and technical complexities of virtual desktops. Simply answer one of five questions and post the link to your answer in the discussion [...]
Answer Question
| May 4, 2012 2:23 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Interested in desktop virtualization? This week’s free IT book is just what you need. Michael Fox’s Demystifying the Virtual Desktop Starting with Desktop Virtualization is a quick read that breaks down the business and technical complexities of virtual desktops. Simply answer one of five questions and post the link to your answer in the discussion [...]
Answer Question
| May 4, 2012 2:23 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Free SQL software with interface to enter data
Hi, I need to enter about 5000 lines of data with about 10 columns. and then i would query the data (by lets say sql, but i am open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view [...]
Answer Question
| October 17, 2011 10:08 PM
Data entry, Free software, Freeware, SQL, SQL Query
Hi, I need to enter about 5000 lines of data with about 10 columns. and then i would query the data (by lets say sql, but i am open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view [...]
Answer Question
| October 17, 2011 10:08 PM
Data entry, Free software, Freeware, SQL, SQL Query
function block calculation module
Hello, I would like to know how to read this code and what the outcome would be. its writtin in a calculation function block which typically includes IF-THEN-ELSE, DO-WHILE, etc. statements. out1 := (in2 = 0) ? 0 : ((in1 & in3) > 0); of course in1/2/3 are the inputs, out1 is the output. Is [...]
Answer Question
| October 17, 2011 12:07 AM
Calculating fields, VBScript Functions, VBScript Statements, Visual Basic, Visual Basic Script
Hello, I would like to know how to read this code and what the outcome would be. its writtin in a calculation function block which typically includes IF-THEN-ELSE, DO-WHILE, etc. statements. out1 := (in2 = 0) ? 0 : ((in1 & in3) > 0); of course in1/2/3 are the inputs, out1 is the output. Is [...]
Answer Question
| October 17, 2011 12:07 AM
Calculating fields, VBScript Functions, VBScript Statements, Visual Basic, Visual Basic Script
IT Scripts compilation
This is just a small compilation of questions in which a script was provided as part of the answer. Having them under the IT Scripts tag could help others find them when needed. A small Windows’ bat script to dinamically construct a SQL Talk backup script according to the current system date: Embed date in [...]
Answer Question
| October 18, 2011 2:59 PM
Bat script, Centura, IT Scripts, SQL Talk, VB script, Windows
This is just a small compilation of questions in which a script was provided as part of the answer. Having them under the IT Scripts tag could help others find them when needed. A small Windows’ bat script to dinamically construct a SQL Talk backup script according to the current system date: Embed date in [...]
Answer Question
| October 18, 2011 2:59 PM
Bat script, Centura, IT Scripts, SQL Talk, VB script, Windows
Test environment
I work as a Test coordinator for a hospital org where we do not have a dedicated Test team.I lead and coordiante the test efforts with set of end user SME’s who do not have testing background. We are designing and building the configuration of the new system (this an off-the -Shelf product) Can you [...]
Answer Question
| January 10, 2012 7:56 PM
Acceptance testing, Test Engineer
I work as a Test coordinator for a hospital org where we do not have a dedicated Test team.I lead and coordiante the test efforts with set of end user SME’s who do not have testing background. We are designing and building the configuration of the new system (this an off-the -Shelf product) Can you [...]
Answer Question
| January 10, 2012 7:56 PM
Acceptance testing, Test Engineer
Open IT Forum: What tech CEO would you vote for?
Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts — or your vote — and we’ll share 50 Knowledge Points!
Answer Question
| March 9, 2012 7:46 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts — or your vote — and we’ll share 50 Knowledge Points!
Answer Question
| March 9, 2012 7:46 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Lotus SmartSuite to MS Office 2003 Conversion Software
I am looking at ways of converting Lotus SmartSuite files to MS Office 2003 files. I have seen software that will convert certain componentstypes of SmartSuite files but I am looking for an automated tool that will scan a hard drive or network share, identify the files with SmartSuite extensions and then convert them to [...]
Answer Question
| October 11, 2011 2:44 PM
Automation, Lotus SmartSuite, Office 2003
I am looking at ways of converting Lotus SmartSuite files to MS Office 2003 files. I have seen software that will convert certain componentstypes of SmartSuite files but I am looking for an automated tool that will scan a hard drive or network share, identify the files with SmartSuite extensions and then convert them to [...]
Answer Question
| October 11, 2011 2:44 PM
Automation, Lotus SmartSuite, Office 2003
Image in Oracle 8i
i have connect vb and oracle. i want to store a image in oracle 8i throw vb? plz help me
Answer Question
| October 11, 2011 12:29 PM
Oracle 8i, Oracle Query, Visual Basic
i have connect vb and oracle. i want to store a image in oracle 8i throw vb? plz help me
Answer Question
| October 11, 2011 12:29 PM
Oracle 8i, Oracle Query, Visual Basic
Creating a dynamic data center best practices (sponsored webcast)
In this webcast, learn how integrating the computer and network environments together can enable the network to be virtualization aware; how dynamic automation of virtual machines can simplify operations; how the network can track the movement of VMs; and how the network can dynamically reconfigure as the virtual computer environment changes. JOIN THE WEBCAST ON [...]
Answer Question
| October 10, 2011 1:17 PM
Automation, DataCenter, Sponsored Webcast, Virtual Machines, Virtualization
In this webcast, learn how integrating the computer and network environments together can enable the network to be virtualization aware; how dynamic automation of virtual machines can simplify operations; how the network can track the movement of VMs; and how the network can dynamically reconfigure as the virtual computer environment changes. JOIN THE WEBCAST ON [...]
Answer Question
| October 10, 2011 1:17 PM
Automation, DataCenter, Sponsored Webcast, Virtual Machines, Virtualization
How to get into the BPM Field
How can I get requisite IT training to work in the BPM Field without going back to college? I am a business major
Answer Question
| December 28, 2011 4:18 AM
BPM, IT training
How can I get requisite IT training to work in the BPM Field without going back to college? I am a business major
Answer Question
| December 28, 2011 4:18 AM
BPM, IT training
EXTENDED: IT Scripts Contest now ends October 17
It’s not too late! IT Knowledge Exchange is extending its latest contest: Is your script 3-dimensional? You don’t have to be an IT Script Shakespeare to get in on the contest: Did you know you can win a Nintendo 3DS for just leaving a great comment on one of the entries? Check out the entries [...]
Answer Question
| March 31, 2012 3:30 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
It’s not too late! IT Knowledge Exchange is extending its latest contest: Is your script 3-dimensional? You don’t have to be an IT Script Shakespeare to get in on the contest: Did you know you can win a Nintendo 3DS for just leaving a great comment on one of the entries? Check out the entries [...]
Answer Question
| March 31, 2012 3:30 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Job Scheduler affecting environment variable
In CL program I am using QIBM_QSH_CMD_OUTPUT environment variable to direct output to STDOUT and then overriding this to database file. This is to capture logging from sftp server, accessed via batch script. When I run the CL program using SBMJOB from command line it outputs logging to DB file. When I call the CL [...]
Answer Question
| March 31, 2012 2:21 PM
CL Program, iSeries job scheduler, Job scheduling, QSH environment variable, SBMJOB
In CL program I am using QIBM_QSH_CMD_OUTPUT environment variable to direct output to STDOUT and then overriding this to database file. This is to capture logging from sftp server, accessed via batch script. When I run the CL program using SBMJOB from command line it outputs logging to DB file. When I call the CL [...]
Answer Question
| March 31, 2012 2:21 PM
CL Program, iSeries job scheduler, Job scheduling, QSH environment variable, SBMJOB
Python Script To Download Wallpapers from InterfaceLift
Language: Python Purpose: Downloads Wallpapers from InterfaceLift and stores them in your home Folder Here is the Code: #!/usr/bin/env python import urllib2 import urllib import re import os import threading import sys class IliftDownloader(object): """Downloads InterfaceLift wallpappers """ def __init__(self,dir = os.environ['HOME']+"/IliftWallpapers",nThreads=5): """ """ self.__totalpages = -1 self.__currentPageNumber = -1 self.__currentImage = -1 self.__approximateImageTotal = [...]
Answer Question
| April 30, 2012 1:02 PM
Contests, IT Scripts, Python, Python scripts, Wallpaper
Language: Python Purpose: Downloads Wallpapers from InterfaceLift and stores them in your home Folder Here is the Code: #!/usr/bin/env python import urllib2 import urllib import re import os import threading import sys class IliftDownloader(object): """Downloads InterfaceLift wallpappers """ def __init__(self,dir = os.environ['HOME']+"/IliftWallpapers",nThreads=5): """ """ self.__totalpages = -1 self.__currentPageNumber = -1 self.__currentImage = -1 self.__approximateImageTotal = [...]
Answer Question
| April 30, 2012 1:02 PM
Contests, IT Scripts, Python, Python scripts, Wallpaper
Return only one word– SQL
Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. [...]
Answer Question
| March 31, 2012 7:12 PM
Oracle, Oracle SQL, SQL, SQL Server
Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. [...]
Answer Question
| March 31, 2012 7:12 PM
Oracle, Oracle SQL, SQL, SQL Server
How can do iSQl*Plus login for DBA
I want to create iSQL*Plus login for DBA. How can i do this ?
Answer Question
| March 31, 2012 4:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
I want to create iSQL*Plus login for DBA. How can i do this ?
Answer Question
| March 31, 2012 4:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
Error Message in SQL Server 2008 code.
Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager, Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr ON Emp.ManagerID = Mgr.EmployeeID ORDER BY MgrID, E_ID; [em]When [...]
Answer Question
| March 31, 2012 11:20 AM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008
Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager, Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr ON Emp.ManagerID = Mgr.EmployeeID ORDER BY MgrID, E_ID; [em]When [...]
Answer Question
| March 31, 2012 11:20 AM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008
INZSR with RETURN & INLR
Hi There, How INZSR will work with RETURN & *inLR *ON. 1:->I mean Pgm A is calling Pgm B.Pgm B is using INZSR & RETURN .So how INZSR will work during the 2nd call to PgmB .I mean when Pgm B got called 2nd time then control will pass to INZSR or Not? 2:->Pgm A [...]
Answer Question
| March 31, 2012 7:29 AM
*INZSR, Coding, RPGLE
Hi There, How INZSR will work with RETURN & *inLR *ON. 1:->I mean Pgm A is calling Pgm B.Pgm B is using INZSR & RETURN .So how INZSR will work during the 2nd call to PgmB .I mean when Pgm B got called 2nd time then control will pass to INZSR or Not? 2:->Pgm A [...]
Answer Question
| March 31, 2012 7:29 AM
*INZSR, Coding, RPGLE
Parsing a XML file with Chinese Characters in AS/400
I am working on a project which require to parse a XML file (in UTF-8 encoding) and put the value into a AS/400 physical file by using JAVA. However, one of the tags in XML may contain both Traditional Chinese and Simplified Chinese characters. The field in the physical file has already defined as DBCS [...]
Answer Question
| March 31, 2012 4:33 AM
AS/400, CCSID, Java, UTF-8, XML, XML development, XML File Creation
I am working on a project which require to parse a XML file (in UTF-8 encoding) and put the value into a AS/400 physical file by using JAVA. However, one of the tags in XML may contain both Traditional Chinese and Simplified Chinese characters. The field in the physical file has already defined as DBCS [...]
Answer Question
| March 31, 2012 4:33 AM
AS/400, CCSID, Java, UTF-8, XML, XML development, XML File Creation
