Script that can rename from CSV/serial join domain
Hi, I’m after a script that would be able to rename a computer based on the machines serial number collected from the machine then i want it to look up the reference in a CSV file rename to the given name, add to the domain and reboot all automatically. Does anyone have such a script? [...]
Answer Question
| November 9, 2012 6:56 AM
.CSV files, VBS
Hi, I’m after a script that would be able to rename a computer based on the machines serial number collected from the machine then i want it to look up the reference in a CSV file rename to the given name, add to the domain and reboot all automatically. Does anyone have such a script? [...]
Answer Question
| November 9, 2012 6:56 AM
.CSV files, VBS
strsql
I need to know how to get the record count for a particular year. the date field is in YYYYMMDD format. I tried the query select SUBSTR(PLGLDT,0,4) AS YEAR, COUNT(*) AS “RECORD COUNT” FROM BPCSF60/APL GROUP BY SUBSTR(PLGLDT,0,4) ORDER BY SUBSTR(PLGLDT,0,4) DESC. But i am getting error “Argument 2 of substringing function not valid”. Can [...]
Answer Question
| July 12, 2012 5:26 AM
AS/400, AS/400 error messages, SUBSTR
I need to know how to get the record count for a particular year. the date field is in YYYYMMDD format. I tried the query select SUBSTR(PLGLDT,0,4) AS YEAR, COUNT(*) AS “RECORD COUNT” FROM BPCSF60/APL GROUP BY SUBSTR(PLGLDT,0,4) ORDER BY SUBSTR(PLGLDT,0,4) DESC. But i am getting error “Argument 2 of substringing function not valid”. Can [...]
Answer Question
| July 12, 2012 5:26 AM
AS/400, AS/400 error messages, SUBSTR
Filter SQL Replication Deletes by user
I am in the process of setting up replication from sql 2008r2 to Oracle 11. I have one requirement that is giving me some issues. My sql db is the publisher and currently maintains data from year 1. The Oracle subscriber will maintain 7 years data. After the initial snapshot the sql db will only [...]
Answer Question
| July 11, 2012 6:13 PM
Replicating databases, Replication, SQL replication
I am in the process of setting up replication from sql 2008r2 to Oracle 11. I have one requirement that is giving me some issues. My sql db is the publisher and currently maintains data from year 1. The Oracle subscriber will maintain 7 years data. After the initial snapshot the sql db will only [...]
Answer Question
| July 11, 2012 6:13 PM
Replicating databases, Replication, SQL replication
Garbled Emails
Why does Lotus Notes 8.5 translate forwarded emails into Greek and how to do I fix?
Answer Question
| July 11, 2012 4:01 PM
Email, Lotus Notes 8.5
Why does Lotus Notes 8.5 translate forwarded emails into Greek and how to do I fix?
Answer Question
| July 11, 2012 4:01 PM
Email, Lotus Notes 8.5
Select Statement & Where Clause ….
On an ASP web page there is a Text Box with default Values for different records. The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called ‘BUSINESS_UNIT’. On the same page i have created a Combo Box populated by [...]
Answer Question
| July 11, 2012 3:31 PM
ASP, SQL Server 2008, VBScript
On an ASP web page there is a Text Box with default Values for different records. The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called ‘BUSINESS_UNIT’. On the same page i have created a Combo Box populated by [...]
Answer Question
| July 11, 2012 3:31 PM
ASP, SQL Server 2008, VBScript
Excel Error Message
How do I clear error message #value#
Answer Question
| July 11, 2012 1:29 AM
Excel 2000
How do I clear error message #value#
Answer Question
| July 11, 2012 1:29 AM
Excel 2000
Help with internet speed.
So me and my roommate are both hard wired into a router he has the first port and i have the 2nd…his computer is older and is damaged a bit. (4g ram prolly 2ghz). My computer is 12g ddr3 and 2.6 ghz…now i pull off the router about 1.0 Gbps and hes getting roughly 65 [...]
Answer Question
| July 10, 2012 10:33 PM
Bandwidth limits, ethernet cable, Speed issues, Streaming Video, torrents
So me and my roommate are both hard wired into a router he has the first port and i have the 2nd…his computer is older and is damaged a bit. (4g ram prolly 2ghz). My computer is 12g ddr3 and 2.6 ghz…now i pull off the router about 1.0 Gbps and hes getting roughly 65 [...]
Answer Question
| July 10, 2012 10:33 PM
Bandwidth limits, ethernet cable, Speed issues, Streaming Video, torrents
RPGILE SERVICE PGM ON V6R1
Hi, We just move our production from V5R4 to V6R1 during testing we found that our service PGM are not returning proper value . When i run the same service PGM on V5R4 it return correct value . We found that the return value coming from Service Pgm is Junk in V6R1. Your Support is [...]
Answer Question
| July 10, 2012 3:10 PM
AS/400
Hi, We just move our production from V5R4 to V6R1 during testing we found that our service PGM are not returning proper value . When i run the same service PGM on V5R4 it return correct value . We found that the return value coming from Service Pgm is Junk in V6R1. Your Support is [...]
Answer Question
| July 10, 2012 3:10 PM
AS/400
Removing user
How do I remove a user someone’s from Salesforce?
Answer Question
| July 10, 2012 1:53 PM
removing, Salesforce, User
How do I remove a user someone’s from Salesforce?
Answer Question
| July 10, 2012 1:53 PM
removing, Salesforce, User
How to find a large size object or fast growing object ?
Few days back we had an issue where DASD went up to 97% and even higher… Due to a user who have created a large file: Library . . . . . . : ABC Object Type Attribute Text XYZ *FILE ********** “Object with size has grown extremely High” We took a service dump and [...]
Answer Question
| July 10, 2012 12:19 PM
DASD
Few days back we had an issue where DASD went up to 97% and even higher… Due to a user who have created a large file: Library . . . . . . : ABC Object Type Attribute Text XYZ *FILE ********** “Object with size has grown extremely High” We took a service dump and [...]
Answer Question
| July 10, 2012 12:19 PM
DASD
Find a string in text file using MS Access
I would like to read a multi-row text file, from inside MS Access, search for a string and returns all its occurences. Sample file: ———— Patch 123456 : applied on Wed Jun 27 15:42:09 CEST 2009 Created on 23 Mar 2009, 00:48:16 hrs PST8PDT … Patch 654321 : applied on Wed Jun 25 15:41:56 CEST [...]
Answer Question
| July 10, 2012 11:11 AM
MS Access, Search string
I would like to read a multi-row text file, from inside MS Access, search for a string and returns all its occurences. Sample file: ———— Patch 123456 : applied on Wed Jun 27 15:42:09 CEST 2009 Created on 23 Mar 2009, 00:48:16 hrs PST8PDT … Patch 654321 : applied on Wed Jun 25 15:41:56 CEST [...]
Answer Question
| July 10, 2012 11:11 AM
MS Access, Search string
Outlook calendar issue
I have Microsoft outlook 2010.In which shared calendar and calendar permissions are graded out.I have exchange account.Please help me to find out the solution
Answer Question
| July 10, 2012 7:13 AM
Microsoft Outlook 2010, Microsoft Outlook Calendar
I have Microsoft outlook 2010.In which shared calendar and calendar permissions are graded out.I have exchange account.Please help me to find out the solution
Answer Question
| July 10, 2012 7:13 AM
Microsoft Outlook 2010, Microsoft Outlook Calendar
2nd Pair of SSH Keys
I need to create second pair of SSH Keys for a User Profile ,Which has already working SSH Keys. If i normally do with SSH KEYGEN -T RSA ,i believe it will overwrite the existing environment and set new keys…Could You Please Advise me how to do this ?
Answer Question
| July 10, 2012 6:37 AM
AS 400, iSeries, SFTP, SSH
I need to create second pair of SSH Keys for a User Profile ,Which has already working SSH Keys. If i normally do with SSH KEYGEN -T RSA ,i believe it will overwrite the existing environment and set new keys…Could You Please Advise me how to do this ?
Answer Question
| July 10, 2012 6:37 AM
AS 400, iSeries, SFTP, SSH
Server 2003 32 bit
I have a server with sbs2003 32 bit, can I introduce a windows 64bit server into the domain? If so will I have to run any kind of patches to make it work? I need to introduce Exchange 64 bit to enhance our mem. limit problems. I would also like to bring in another server [...]
Answer Question
| July 9, 2012 5:11 PM
Small Business Server 2003
I have a server with sbs2003 32 bit, can I introduce a windows 64bit server into the domain? If so will I have to run any kind of patches to make it work? I need to introduce Exchange 64 bit to enhance our mem. limit problems. I would also like to bring in another server [...]
Answer Question
| July 9, 2012 5:11 PM
Small Business Server 2003
Limit Qsecofr to specified workstation
I am aware of the system value for qlmtsecofr, and need to know how to set the specific workstations/devices? Thanks much. Stephen Lewis
Answer Question
| July 8, 2012 9:20 PM
devices, LIMIT, Qlmtsecofr
I am aware of the system value for qlmtsecofr, and need to know how to set the specific workstations/devices? Thanks much. Stephen Lewis
Answer Question
| July 8, 2012 9:20 PM
devices, LIMIT, Qlmtsecofr
exchange 2003 cannot send all of a sudden
I have a client with exchange 2003, who suddenly could not send emails. Receiving and internal relay working fine. All external emails bounced back with:- There was a SMTP communication problem with the recipient’s email server. Please contact your system administrator. Done message tracking and got:- 08/07/2012 15:28 SMTP Store Driver: Message Submitted from store [...]
Answer Question
| July 8, 2012 3:33 PM
Exchange 2003, Exchange 2003 administration
I have a client with exchange 2003, who suddenly could not send emails. Receiving and internal relay working fine. All external emails bounced back with:- There was a SMTP communication problem with the recipient’s email server. Please contact your system administrator. Done message tracking and got:- 08/07/2012 15:28 SMTP Store Driver: Message Submitted from store [...]
Answer Question
| July 8, 2012 3:33 PM
Exchange 2003, Exchange 2003 administration
Object Lock
Some user has locked a file which is in use by a running job , so I’m trying to get end that job (Who locked the file ) so for that i need User Name,Job Name & Job Number.Can some body tell me how can i get these information in my running job & At [...]
Answer Question
| July 8, 2012 1:44 PM
RPG OBJECT LOCK
Some user has locked a file which is in use by a running job , so I’m trying to get end that job (Who locked the file ) so for that i need User Name,Job Name & Job Number.Can some body tell me how can i get these information in my running job & At [...]
Answer Question
| July 8, 2012 1:44 PM
RPG OBJECT LOCK
text to light
Is there a way to darken the words on a page so it can be read more easer? Better resalution , , ,
Answer Question
| July 8, 2012 8:15 AM
clear reading, improve letters visibility, print, TEXT
Is there a way to darken the words on a page so it can be read more easer? Better resalution , , ,
Answer Question
| July 8, 2012 8:15 AM
clear reading, improve letters visibility, print, TEXT
Raid 10
I have a raid 10 4 drive array. Can I add more drives to this setup?
Answer Question
| July 7, 2012 5:19 PM
RAID
I have a raid 10 4 drive array. Can I add more drives to this setup?
Answer Question
| July 7, 2012 5:19 PM
RAID
What will be saved
what will be saved if we isse below commands SAV- Save Object (SAV) SAVSYS -Save System (SAVSYS) SAVSECDTA -Save Security Data (SAVSECDTA) SAVLIB -Save Library (SAVLIB) SAVOBJ -Save Object (SAVOBJ) SAVCHGOBJ- Save Changed Objects (SAVCHGOBJ) SAVDLO- Save Document Library Object (SAVDLO) SAVCFGF
Answer Question
| July 7, 2012 11:41 AM
AS/400, AS400 backups
what will be saved if we isse below commands SAV- Save Object (SAV) SAVSYS -Save System (SAVSYS) SAVSECDTA -Save Security Data (SAVSECDTA) SAVLIB -Save Library (SAVLIB) SAVOBJ -Save Object (SAVOBJ) SAVCHGOBJ- Save Changed Objects (SAVCHGOBJ) SAVDLO- Save Document Library Object (SAVDLO) SAVCFGF
Answer Question
| July 7, 2012 11:41 AM
AS/400, AS400 backups
