Create a field for the chat of VBS
Many clients like to post their issues about VBS problems to something forum like VB.net or VB6 in MSDN，however I don't think it's a nice way because there's a huge different between the two languages and I suggest Microsoft creating a new place for VBS specially……Now we can only go to（Not very good……）:(
Visual Basic for Applications (VBA)
http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=74&SiteID=1
(This is a Microsoft MSDN site)
Alternatively, when developing addins for Office 2003 or 2007 products:
Visual Studio Tools for Office
http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=16&SiteID=1
(This is a Microsoft MSDN site)
For VBScript questions, search Google for a variety of resources or:
VBScript Forums
http://www.visualbasicscript.com/ (A Non-Microsoft Site)
Reply:
Questions about VBScript should be asked in "The Scripting Guys Forum", linked here:
http://social.technet.microsoft.com/Forums/en-US/ITCG/threads
Richard Mueller - MVP Directory Services
------------------------------------
Reply:
Oops……MANY THANKS，I'll let them move there……Questions about VBScript should be asked in "The Scripting Guys Forum", linked here:
http://social.technet.microsoft.com/Forums/en-US/ITCG/threads
Richard Mueller - MVP Directory Services
------------------------------------
Recovering a database using log files
HI,
My database became corrupted and I didnt realise that that the database was not increasing in size or being modified. So I tried to repair the database with the Eseutil /p command. This did not work and I hadto restore an old version of the database I had copied to a different folder. But then i noticed 7gb of log files in the log folder. I have read I can use these to rebuild the database. So now I have an old version of the database and the 7gb of log files. How can I merge these to rebuild the database?
Thanks
MCP,MCSA,MCSE,MCTS,MCITP Enterprise Administrator
Reply:
Hi Haza,
First off, the solution you are trying to achieve is only possible if your mailbox database is from you last full backup, and the log files have changes from there.
If this is the case, have a look at: http://demazter.wordpress.com/2010/04/29/mailbox-recovery-exchange-2010/ for how to replay the log files.
If you have a virtualized environment, I would take a snapshot of the DC and the Exchange server, bring it online on a isolated subnet, and try playing around with it there so you don't risk messing up your production environment.
Good luck.
Microsoft: MCP, MCTS, MCITP: SA, MCITP: EA || CIW: Associate, Security Professional || CompTIA: A+, Server+, Linux+ || Citrix: CCA on XenApp || HP: ASP, ASP:SMB || Astaro: ACA, ACE
------------------------------------
Reply:
HI,
I can't get the above to run I tried
C:\Users\johnha>ESEUTIL /r e01 /Lf:"C:\Program Files\Microsoft\Exchange Server\V
14\Mailbox\Mailbox Database 0996298158" /sc:"C:\Program Files\Microsoft\Exchange
Server\V14\Mailbox\Mailbox Database 0996298158" /dg:"M:\Exchange Database\Atlas
\Mailbox Database 0996298158\Mailbox Database 0996298158.edb" /i
Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
Version 14.01
Copyright (C) Microsoft Corporation. All Rights Reserved.
Initiating RECOVERY mode...
Logfile base name: e01
Log files: f:C:\Program Files\Microsoft\Exchange Server\V14\Mailbox\
Mailbox Database 0996298158
System files: c:C:\Program Files\Microsoft\Exchange Server\V14\Mailbox\
Mailbox Database 0996298158
Database Directory: g:M:\Exchange Database\Atlas\Mailbox Database 0996298158\
Mailbox Database 0996298158.edb
Performing soft recovery...
Operation terminated with error -1811 (JET_errFileNotFound, File not found) afte
r 0.0 seconds.
I'm pretty sure thats the correct locations for them all. Just downloading that tool to try now. Lets hope it works
MCP,MCSA,MCSE,MCTS,MCITP Enterprise Administrator
------------------------------------
Reply:
Couldnt get that tool to work, I added the directories and it said it was not in a clean state, then it just went back to the initial screen. Guess I need a license for it.
Can anyone else help? Is there any good free tools out there?
MCP,MCSA,MCSE,MCTS,MCITP Enterprise Administrator
------------------------------------
Reply:
MCP,MCSA,MCSE,MCTS,MCITP Enterprise Administrator
------------------------------------
Reply:
DigiScope can pull them from a machine that has Outlook Installed and;
- you can do so during setup with the install wizard as outlined here http://www.lucid8.com/download/documentation/DSWebHelp/DigiScopeHelp.htm
- Or it will ask you for the files when you first attempt to load an offline database as outline here http://www.lucid8.com/download/documentation/DSWebHelp/DigiScopeHelp.htm
NOTE:
- I would suggest pulling from a machine with Outlook 2007 rather then 2010 since there are some issues with Outlook 2010.
- In either of the options above you can either put in the machine name or IP address of a machine that has Outlook installed OR you can let DigiScope scan the network for machines that meet the criteria
If you have any additional questions or concerns you can contact our support department and they will be happy to assist vie email or even WebEx if needed.
Troy Werelius
www.Lucid8.com
Search, Recover, & Extract Mailboxes, Folders, & Email Items from Offline EDB's and Live Exchange Servers with Lucid8's DigiScope
------------------------------------
Reply:
I still cannot get digiscope to find the dll's it i after. I have searched the outlook machine and the exchange machine with no luck.
Is there a way I can build the database just from the log files without using an edb? I tried to mount without an edb but it did not work.
Thanks
MCP,MCSA,MCSE,MCTS,MCITP Enterprise Administrator
------------------------------------
Reply:
- That's odd, have you attempted to contact our support department so they can assist via WebEx?
- No you need to at least have the original database at inception and all logs from that point forward OR a database from another point in time and all logs from that point forward
- NOTE: You can only do a roll-up one time, i.e. once you roll-up a set of logs and mount you cannot do a subsequent roll-up so if you rolled up logs previously and didn't get the desired results then you will need to recover a new copy of the EDB so that it can accept logs during roll-up. When you recover the DB ensure you tell it to NOT MOUNT and NOT ROLLUP the logs so that you can then attempt to roll-up all the logs, i.e. the ones fom the backup as well as the additional 7GB.
Troy Werelius
www.Lucid8.com
Search, Recover, & Extract Mailboxes, Folders, & Email Items from Offline EDB's and Live Exchange Servers with Lucid8's DigiScope
------------------------------------
Reply:
I have contacted a data recovery company in regards to the database with no edb file. They believe that due to the fact nothing was written to the edb file as it has never had a graceful shutdown since mount that the datashould be recoverable at a high cost.
As for database 2
Is there anyway we can get the new logs written to the older database?
EDIT: I think ive done it!
Now just got to restore database 1 from only logs. Not given up hope yet
Thanks
MCP,MCSA,MCSE,MCTS,MCITP Enterprise Administrator
- Edited by Haza1981 Tuesday, January 3, 2012 1:54 PM
------------------------------------
Reply:
- I would be shocked if anyone can rescue data without a database from some point in time. If you have the original EDB when it was first created its possible, but otherwise it cant be done.
- What is it that you think you have done?
Troy Werelius
www.Lucid8.com
Search, Recover, & Extract Mailboxes, Folders, & Email Items from Offline EDB's and Live Exchange Servers with Lucid8's DigiScope
------------------------------------
Reply:
I have managed to repair the edb file to a point where I can create a recovery edb out of it and view statistics. I tried to do a New-MailboxRestoreRequest but it is queued? not sure why. Anyway I'm going to try and mount the database tonight to se what happens.
I'll let you know the outcome.
I did see an article that sai stick all the log files in the log folder without the database and try mount it. Say no tot he error message and it creates a new fresh edb file. Mount again and the logs are attached.
This does not happen! But i'm not giving up. All te info is in the logs I just need to extract it.
MCP,MCSA,MCSE,MCTS,MCITP Enterprise Administrator
------------------------------------
Reply:
I have done it!!!!!!
I used hard drive recovery tool called R-studio. Took hours to run but found a version of the fil tat matched the logs. Recovered it fine and used eseutil to replay the logs. Hey presto..I now have all mails back.
Thanks so much guys for you time and help
MCP,MCSA,MCSE,MCTS,MCITP Enterprise Administrator
------------------------------------
Reply:
Troy Werelius
www.Lucid8.com
Search, Recover, & Extract Mailboxes, Folders, & Email Items from Offline EDB's and Live Exchange Servers with Lucid8's DigiScope
------------------------------------
Reply:
I created a guide to help other people in this situation. Its located here http://www.cloud42.co.uk/2012/01/part-13-database-repair-on-exchange.html
MCP,MCSA,MCSE,MCTS,MCITP Enterprise Administrator
------------------------------------
'Provision For' missing off AD MA
I am using version 4.0.3606.2 and unable to get 'Provision For' section for Exchange configuration to appear on the Configure Extensions page of an AD MA .
I created the AD MA prior to the exchange 2010 schema updates being installed. I can create a new AD MA and the 'Provision For' section is present. I exported the configuration of the new AD MA located the relevant configuration items for exchange and merged the relevant config with the export of the old AD MA and (disregarding the <!--WARNING>) tried to reimport it into the old AD MA. The AD MA disregards the new config.
I can import the AD MA config into a new MA and the Provision For appears. The issue with this is that when I attempt to switch the Sync config over to use the newly created MA,it expects me to reenter all the information in the Sync rule. This is going to take too much time.
Does anyone know of a workaround for this?
Thanks,
Matt
- Changed type Markus VilcinskasMicrosoft employee Sunday, March 17, 2013 8:53 AM
Reply:
------------------------------------
Reply:
Yes, I have done that. Thanks Thomas.
I did revert to a backup while trying to resolve this and when the schema is not refreshed, the update MA process detects that the exchange attributes I am trying to write to are not present in the MAs schema and throws an error.
After updating the schema, the update no longer throws an error, but it does not save the config either.
------------------------------------
How to ask a question efficiently in TechNet forum
Thank you for posting in TechNet forum. The online problem solving can be relatively time consuming because it may demand several messages back and force to fully understand the symptom and background, especially at the very beginning. Here are a few suggestions that help you get the best answer to your question as quickly as possible.
When You Ask
1. Selecting a good title which summarizes the specific problem you have. It will be the one of the main driving forces for others to want to actually read your item. Choosing a badly-formatted title will drive people away, thinking that since the title is so badly written, so must be the information and the question within the thread.
2. Provide all the necessary information in your initial post. The following information would be very helpful:
- Symptom description: Detailed description of the problem. If you receive any error messages, please let us know the exact error WORD BY WORD.
- Environment: The system environment, such as your OS/application version, your network topology, and your domain environment, etc.
- Any recent relevant configuration change(s): If the issue started to occur after installing any application/updates or changing the configuration, please let us know.
- Any additional information. Tell what you have done prior to asking your question. This will help us understand that you've done so far.
3. Write in a clear language. Avoiding spelling mistakes or grammatical errors. Don't type IN ALL CAPS, which in most cases is read as shouting and considered rude.
4. Keep with the same thread. Do not refer to a post you made last year, and above all, Please come back. There are hundreds and thousands of posts where we have seen people given great and wonderfully long answers yet no reply from the original poster.
5. Be courteous to reply, even if it's to say. "I've given up" or thanks that worked. (This helps the whole community when you do this, and makes the people who donate time, warm and fuzzies.)
When answered
Give Positive Feedback. Once you've received a correct answer to your question, either from a Microsoft employee, an MVP, or the community in general, pleases replies that the issue or question has been answered. And if possible mark the solution as answered: This step is important, since it lets other people benefit from your posts.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
i cannot add new posts. Only replies. :-(
HOW I COULD MAKE A NEW THREAD!!!!!!!!!!!
I don't know how I tried everything there is not solution for create thread here!
------------------------------------
Reply:
You're probably looking for a "New Thread" button.
Click the big button on the right side that says, "Ask a Question in the forums."
- Edited by Jason-IT Friday, April 20, 2012 11:50 PM
------------------------------------
SSIS Loading Data from Variable value to next 5 years
Hi Experts ,
I am working on SSIS 2008,I am Loading Data from Excel source to SQL table.
My Excel source have 61 Colummn,
1st Column is ProjectID
2nd to 61st column are Month Name from Apr to MAr for 5 years.i.e
5year x12month=60Columns.
My Excel sheet contain DatePart in the Last ,example Revenue_File_2010.
I am taking Datepart i.e Year "2010" of Excel sheet in a SSIS Variable,
I get Excel Data In Below Format.
ProjectID Apr May JUne July Aug sep Oct Nov Dec Jan Feb Mar......Apr May June....
111 1000 2000 2500 3000 3500 4000 5000
I am Doing a Unpivot of This ,So I get 3 Column 1)ProjectID 2)BudgetMonths 3)Amount
ProjectID BudgetMOnths Amount
111 2010-04-01 1000 to
111 2011-01-01 3500 like This..
ISSue: If the Data is Of One Year,i,e from Apr to MAr I am able to handle This by Using below Expression in Derived Column
Substring(Months,1,3)="Jan"||Substring(Months,1,3)="Feb"||Substring(Months,1,3)="Mar" ?
Substring(Months,1,3)+"-"+(DT_Str,2,1252)(@User::FileDate+1):(DT_Str,2,1252)(@User::FileDate)
Note: Above Expression might not have 100 per correct sysntex,because I am typing this with Out Copying Expression from My Derived Colmn,which works file there.
Value of above Expression goes in my BudgetMonth column which has Date as DataType
But How could I handle this when I get 5 year of Data,Means I am Capturing DatePart of Excel file in
Variable ,So In my BudgetMonth column ProjectID and Amount should come for Variable Value to Next 4 years.(Total 5 years)
ProjectID Amount BudgetMonth
111 2010-04-01
to
111 2015-03-01
and BudgetMonth Should start from year Value Available In Variable
So That for Each ProjectId I can Load Amount for Five Year
Any Help??
- Edited by MS308 Friday, April 20, 2012 6:10 PM
Reply:
A couple things I need to know - what are the column names shown in the rowset coming out from the Excel Source (when you are reading all five years of columns)? How do you have your Pivot configured?
 | Talk to me now on |
------------------------------------
Saving a Word document with Powershell
I'm trying out a script that i found online that will enter data into a word document, then save and close the document. it inputs the data into word but it does not save, I get "Argument types do not match". Can someone tell me what I need to do different:
function ipaddr
{
param([string]$CompName)
$wmi = Get-WmiObject -Query "SELECT * from Win32_NetworkAdapterConfiguration WHERE IPEnabled='true'" -ComputerName $CompName #-Credential $cred
foreach ($nic in $wmi)
{
$nic.IPAddress
}
}
function osver
{
param([string]$CompName)
$osver = Get-WmiObject -Query "SELECT Caption from Win32_OperatingSystem" -ComputerName $CompName #-Credential $cred
$osver.Caption
}
# specify full path to the list of servers you want to scan.
$hostInputFile = "C:\sct\servers.txt"
if (! (test-path $hostInputFile))
{
throw "$($hostInputFile) is not a valid path."
}
# specify fill path to the word doc where bookmarks are defined.
$docTemplate = "C:\sct\template.docx"
if (! (test-path $docTemplate))
{
throw "$($docTemplate) is not a valid path"
}
$computers = Get-Content $hostInputFile
$msWord = New-Object -Com Word.Application
foreach ($computer in $computers)
{
$wordDoc = $msWord.Documents.Open($docTemplate)
$wordDoc.Activate()
#defines IP address input
$objRange = $wordDoc.Bookmarks.Item("ip").Range
$objRange.Text = ipaddr -CompName $computer
$wordDoc.Bookmarks.Add("ip",$objRange)
#defines OS version input
$objRange = $wordDoc.Bookmarks.Item("osversion").Range
$objRange.Text = osver -CompName $computer
$wordDoc.Bookmarks.Add("osversion",$objRange)
#defines hostname input (from the $computer value above)
$objRange = $wordDoc.Bookmarks.Item("hostname").Range
$objRange.Text = $computer
$wordDoc.Bookmarks.Add("hostname",$objRange)
# Save the document to disk and close it. CHange $filename path to suit your environment.
$filename = "C:\sct\" + $computer + ".docx"
$wordDoc.SaveAs([REF]$filename)
$wordDoc.Close()
}
$msWord.Application.Quit()
SMaximus7
- Changed type Tiger LiMicrosoft employee Tuesday, January 24, 2012 6:43 AM
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
I see the OP has not replied...
I get the same error running Word 2010 on the line $wordDoc.SaveAs([REF]$filename).
"Argument types do not match"
I am also running PowerShell V3, and there is a bug filed with connect: http://connect.microsoft.com/PowerShell/feedback/details/730479/the-saveas-method-in-the-word-application-com-object-fails-in-powershell-3-0-beta
I am running Server 2008 R2, and the Windows 7 workaround does not resolve the issue...
Karl
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
My Blog: http://unlockpowershell.wordpress.com
My Book: Windows PowerShell 2.0 Bible
My E-mail: -join ("6B61726C6D69747363686B65406D742E6E6574"-split"(?<=\G.{2})",19|%{[char][int]"0x$_"})
- Edited by Just Karl Friday, April 20, 2012 5:24 PM
------------------------------------
Reply:
Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
------------------------------------
Reply:
SMaximus7
------------------------------------
Reply:
Justin:
OverloadDefinitions
-------------------
System.Void SaveAs([ref] System.Object FileName, [ref] System.Object FileFormat, [ref] System.Object LockComments,
[ref] System.Object Password, [ref] System.Object AddToRecentFiles, [ref] System.Object WritePassword, [ref]
System.Object ReadOnlyRecommended, [ref] System.Object EmbedTrueTypeFonts, [ref] System.Object
SaveNativePictureFormat, [ref] System.Object SaveFormsData, [ref] System.Object SaveAsAOCELetter, [ref] System.Object
Encoding, [ref] System.Object InsertLineBreaks, [ref] System.Object AllowSubstitutions, [ref] System.Object
LineEnding, [ref] System.Object AddBiDiMarks)
Karl
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
My Blog: http://unlockpowershell.wordpress.com
My Book: Windows PowerShell 2.0 Bible
My E-mail: -join ("6B61726C6D69747363686B65406D742E6E6574"-split"(?<=\G.{2})",19|%{[char][int]"0x$_"})
------------------------------------
Reply:
Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
------------------------------------
Will DPM 2010 automatically expand replica and recovery point volumes for SCR storag group backups?
- Changed type Yegor Startsev Friday, April 5, 2013 8:48 AM lack of activity
Reply:
Hi Pete,
Do you still need help with for this post?
Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
------------------------------------
Reply:
------------------------------------
Reply:
Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
------------------------------------
Reply:
Pete,
Do you still need help with this? can you give more information on what DPM shows for the initial size? Is it smaller than was it needs to?
Regards, A.Nadar, This posting is provided "AS IS" with no warranties, and confers no rights.
------------------------------------
Updating Exchange 2007 Address List after Cross Migration - HELP
Hi,
I just finished to migrate mailboxes from x.com, also using ADMT, to y.com domain, both with Exchange Servers 2007.
All is just fine about account and mailboxes but when I go to search for a user in OWA it is not possible find any mailboxes migrated yesterday. I already run the Update-Globaladdresslist but nothing appears.
What can I do? If anyone can help me I appreciate.
Thanks for now.
Luiz
Reply:
Run following commands
Get-Recipient | Update-Recipient
Update-addresslist -identity "All users"
Update-addresslist -identity "All groups"
Update-addresslist -identity "All contacts"
Update-globaladdresslist -identity "Default Global address list"
Now check and see if you are able to see the users in GAL
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Hasnain Shaikh| My blogs: http://messagingserversupport.com
------------------------------------
Reply:
Hi Hasnain,
thanks for the replay.
The admin from the x.com domain told me that the addresses where Hidden the I disable the Hidden option and the users appeared to me.
Thanks for the help.
Best Regards.
Luiz
------------------------------------
Reply:
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Hasnain Shaikh| My blogs: http://messagingserversupport.com
------------------------------------
Reply:
Very sorry, that is result of "blind" trust. :-)
Thanks again, Hasnain.
Best Regards.
Luiz
------------------------------------
Exchange 2010 SP1 /Hosting Switch - Missing Mailboxes in Database Backup
Hi DPM Guys :)
i have got a real big problem!
DPM 2010 was used till three days ago (Now i upgraded to DPM 2012 RC to look if it solfs my problem... no, it does not!
The Environment:
Two Exchange 2010 SP1 /Hosting Mode enabled with RU6 Mailbox Servers with DAG and 15 Databases. Additional CAS and HT.
The Database is 52GB on live System and 52GB in Backup, so the Mailboxes should bi in the Backup. But many Mailboxes are missing on DPM recovery view and if i restore the database to RDB i could not see the mailboxes via get-databasestatistics.
Does anybody heared this before? Does anybody know what i can do to backups _ALL_ Mailboxes in /Hosting Mode?
Best Regards!
- Changed type Yegor Startsev Friday, April 5, 2013 8:47 AM lack of activity
Reply:
Hi,
I don't remember seeing an issue like that.
how many mailboxes are missing from the DB?
Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
------------------------------------
Reply:
PendingCompletion,
Is this still an issue?
Regards, A.Nadar, This posting is provided "AS IS" with no warranties, and confers no rights.
------------------------------------
How to migrate non EPM timesheet data into EPM 2010
How to migrate non EPM data into EPM 2010?
I am new to EPM 2010 and have a very complex project I am overseeing at the moment. The project is consolidating various in house and SAAS proejct systems into EPM 2010. Moreover, the data has then to be synched with SAP for Costing and Revenue.
The question is how can I migrate the historical data from other systems (SQL Database format) - Projects and Timesheets. Projects can have a single line item such as "Historical Timesheet Tasks" and then lump all the hours for "Date, User, Historical TImesheet Tasks, Hours". Can I simply push the data into EPM SQL Database?
Any help will be highly appreciated.
Reply:
No, you cannot push into the database directly - you should use the Project Server Interface (PSI). See the SDK for examples and the available methods. Not sure from your desciption above exactly what you are needing to do. http://msdn.microsoft.com/en-us/library/ms512767(office.14).aspx is where you will find the online SDK. Potentially the statusing web service is the one you may need - or the timesheet ones if you are looking to match the non EPM timesheets to the EPM ones..
Best regards,
Brian
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
------------------------------------
Creating a custom functoid to replicate the looping functoid
Please don't ask me why, but I want to create a custom functoid to replicate the looping functoid.
I have searched for the source code for the looping functoid but didn't find anything.
Any one know how to implement this?
- Changed type LeoTangModerator Monday, April 30, 2012 9:56 AM
Reply:
Looping functoid is equivalent of <xsl:for-each>. If you don't want to use the loop functoid then you can directly use it in custom functoid or can use the XSLT Transformations to create similar behavior.
Please mark the post answered your question as answer, and mark other helpful posts as helpful, it'll help other users who are visiting your thread for the similar problem, Regards -Rohit Sharma (http://rohitt-sharma.blogspot.com/)
------------------------------------
Reply:
Thank you for your reply.
I am looking to replicate the looping functoid within a custom functoid(written in C#).
I am looking to see how the code for such a simple thing would be implemented.
I am NOT looking for other ways to do looping.
It is an advanced question I am not expecting a lot of answers.
- Edited by MillaT Friday, April 20, 2012 4:04 PM
------------------------------------
Reply:
Hi,
Lets see where you at with the code and if you are facing any issues may be we can help. Not sure what do u mean by advanced question? You are trying to implement a looping functoid in a custom functoid written in C#. Why would you want to do that unless you have a lot of time at hand.
Regards,
Bali
MCTS: BizTalk Server 2010,BizTalk Server 2006 and WCF
My Blog:dpsbali-biztalkweblog
-----------------------------------------------------
Mark As Answer or Vote As Helpful if this helps.
------------------------------------
Mark As Answer Abuse
I have noticed that there are a lot of answers supplied by moderators who mark their answer as the accepted answer.
This practice needs to stop as it is self serving and it may not be the correct answer to the question and serves it seems to only bolster one's own point total for bragging rights. Only the person who asked a question should be allowed to mark their question as answered where they should provide the details that were specific to that questions resolution.
Even a question has not been updated for some time after a suggestion was made should not be marked by ANYONE as answered as it still may not be exactly what was needed and only the person asking really know what worked or not.
Please stop this self serving policy.
Reply:
I agree with you! That has always been one of my pet peeves as well. I don't think the behavior is going to stop anytime soon though, unfortunately.
The only time I have ever marked my reply as an answer was when the OP has replied and said my post solved his problem, but then didn't mark my reply. I'll ask him to, but if he still doesn't, then I will. This has really only happened a few times.
~~Bonnie Berent DeWitt [C# MVP]
geek-goddess-bonnie.blogspot.com
------------------------------------
Reply:
I see a lot of moderator that propose their answer as answer. After some day they mark it as answer. That is a good way to work in the forum. A lot of users does not mark their answers, on almost 1/3 of my post the moderator had to mark the answer, and it was cleaver answer, not some obscure reply.
For someone that answer a lot, it get fustrating when users don't mark their answer, that way to manage in the forum make it make it better! Don't forget that to be a moderator, you have to get a strong knowledge of the technologie, so most of time their answer are good.
MCP | MCTS 70-236: Exchange Server 2007, Configuring
- Edited by Yagmoth555MVP Wednesday, April 11, 2012 3:18 AM
------------------------------------
Reply:
Even though the moderator has proposed an answer, no one really knows of sure if it was indeed the solution. If it was a great method, suggestion or proposal only one person can answer and truly mark it as the answer.
I am proposing that Microsoft add another category titled something like "Answer Suggested" to allow moderators the ability to mark an unresponsive thread after they send an email to the ticket creator asking if a solution has been found if not they will mark the question "Answer Suggested".
This would give membership a way to search for possible answers to their questions even if a questions originator has not accepted an answer.
------------------------------------
Reply:
~~Bonnie Berent DeWitt [C# MVP]
geek-goddess-bonnie.blogspot.com
------------------------------------
Reply:
If the OP does not come back to the thread to say yay or nay, it should remain as "Proposed Answer" ... just my 2 cents.
~~Bonnie Berent DeWitt [C# MVP]
geek-goddess-bonnie.blogspot.com
Forgive me from editing your response, however great minds think alike and we are in agreement. How does anyone lobby for the change so it stays as the "Proposed Answer" if the OP does not respond? Perhaps the forum needs a permissions change to lock the moderators out of marking the question as answered?
Tell me what is OP?
------------------------------------
Reply:
Like I told, too much user don't mark the answer. The recognition system need a answer... and if you recognize the person that help you bring new people on the forum to help.
And If a moderator mark an answer, you can unselect-it too as a answer as the thread starter, and you just have to report the moderator back as abuse. My 0.02c.
But I agree that the moderator should propose as answer, and mark it as answer later on (usually I see like 3-4 day later)
In all case, I just check if the marked answer was by the thread starter or not, you will have your answer if the user came back.
(I answered you on another thread you started some time ago, but you got asked if the issue was ok or not before the mark as answer. I see nothing wrong there and the answer is ok, it refer you to some reference and ask you further detail)
MCP | MCTS 70-236: Exchange Server 2007, Configuring
- Edited by Yagmoth555MVP Wednesday, April 11, 2012 5:05 PM Added the last comment
------------------------------------
Reply:
Like I told, too much user don't mark the answer. The recognition system need a answer... and if you recognize the person that help you bring new people on the forum to help.
And If a moderator mark an answer, you can unselect-it too as a answer as the thread starter, and you just have to report the moderator back as abuse. My 0.02c.
But I agree that the moderator should propose as answer, and mark it as answer later on (usually I see like 3-4 day later)
In all case, I just check if the marked answer was by the thread starter or not, you will have your answer if the user came back.
MCP | MCTS 70-236: Exchange Server 2007, Configuring
Sorry this is BS, horse pucky or what ever you want to call it.
"The recognition system need a answer" NO it does not.
The recognition system needs a answer to server what purpose? Please explain
Only the person who posted the question would know if the proposed solution worked or not, no one can say it did and for anyone else that may see an answer was proposed that may have a similar problem can try it for themselves.
A proposed answer left unvalidated serves to provide the best possible attempt to assist, without validation NO ONE can say it worked.
------------------------------------
Reply:
"Sorry this is BS, horse pucky or what ever you want to call it. "
Everyone got opinions, I understand your, but I have my own. So lets not start some flame there please. I tried to help BTW on the other thread if you didnt recognized it, and at the same time your thread bumped to get further reading.
""The recognition system need a answer" NO it does not."
Why they did it then ?
"The recognition system needs a answer to server what purpose? Please explain"
Why they did it that way is the question to ask ?
"A proposed answer left unvalidated serves to provide the best possible attempt to assist, without validation NO ONE can say it worked."
Why ? Because any moderator have their knowledge on the technology forum you used, and I thrust them to judge was is ok or not. That will help other user out. An unanswered question without detail is ok, but with a good answer, it better show some other way in the search for everyone else
When you ask for help and don't come back, it's like calling a tech support and put them on hold IMO. What told us that you did not read the answer and it worked ?
MCP | MCTS 70-236: Exchange Server 2007, Configuring
- Edited by Yagmoth555MVP Wednesday, April 11, 2012 5:25 PM
------------------------------------
Reply:
Yag, your cool I'm not bagging on you, just the current system. You're trying to help and it's ok to disagree.
In my world I may be working on a project have a problem and then I may not get back to it for days weeks or months due to other things that need my guidance or intervention, so in marking one of my questions as answered I feel overridden yet my project is on hold. Perhaps I will mark my questions as on hold if I can.
Working as a tech I have frequently seen a ticket resolved without knowing exactly what the solution was, this happens and no one should be offended when it does.
------------------------------------
Reply:
If a moderator marks an answer, and the original poster doesn't unmark it, then I think no one can complain. Clearly, Microsoft would rather have questions resolved instead of left hanging. But it definitely matters to the person that provided the answer. They don't get points or credit toward achievements unless their reply gets marked as an answer. Always, the best outcome is for the original poster to mark the answer, and the person that provided the answer gets more points if the OP marks. That's why I try to wait for 7 days of inactivity before marking answers, but I mark proposed answers in the meantime to kick start things.
Richard Mueller - MVP Directory Services
------------------------------------
Reply:
MCP | MCTS 70-236: Exchange Server 2007, Configuring
- Edited by Yagmoth555MVP Wednesday, April 11, 2012 6:13 PM
------------------------------------
Reply:
Thats the problem, moderators are trying to cash in on points, it's like the cookie monster is watching the cookie jar so they can accumulate more points.They don't get points or credit toward achievements unless their reply gets marked as an answer. Always, the best outcome is for the original poster to mark the answer, and the person that provided the answer gets more points if the OP marks. That's why I try to wait for 7 days of inactivity before marking answers, but I mark proposed answers in the meantime to kick start things.
------------------------------------
Reply:
I don't think you understand my comment. The moderator marks the reply as an answer so the person that posted the reply (not themselves) gets points and credit for achievements (assuming the OP hasn't done the favor already). If a moderator marks their own reply they definitely do not get credit toward achievements, although I think it's true they do get points.
Richard Mueller - MVP Directory Services
------------------------------------
Reply:
Richard --- CJ's original complaint was about moderators who mark their own posts as answers.
CJ --- "OP" stands for Original Poster, the person who started the thread. But it could also mean Original Post, the actual content of that first post. You usually can tell by the context of the sentence which meaning is intended.
I still don't like people marking their own posts as an answer. Yes, it might be great advice and be helpful and all ... but often a poster will describe his problem and none of the responses help him for his specific problem. This is typically because the OP hasn't adequately explained his problem or he has left out some important details. What might then seem to us as a great answer doesn't work for the OP at all. But we don't know that unless he comes back and tells us. In situtations such as this, I think leaving posts marked as Proposed Answer is the best solution.
But hey, nobody ever listens to me ... ;0)
~~Bonnie Berent DeWitt [C# MVP]
geek-goddess-bonnie.blogspot.com
------------------------------------
Reply:
Richard,
If a moderator marks their own reply, the points are not affected. The achievements, I believe, do get affected.
I think it's OK to let moderators mark the response after 7 or more days of inactivity when it's clear that that response was an answer.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
------------------------------------
Reply:
My personal policy is never mark my own replies as answer, so I can't say for sure. I also wait for 7 days of inactivity before marking answers. However I thought Ed Price said that situations where a moderator marked their own reply as answer did not count toward achievements. If I find a link, I'll post it.
Richard Mueller - MVP Directory Services
------------------------------------
Reply:
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
------------------------------------
Reply:
~~Bonnie Berent DeWitt [C# MVP]
geek-goddess-bonnie.blogspot.com
------------------------------------
Reply:
> I see a lot of moderator that propose their answer as answer. After some day they mark it as answer. That is a good way to work in the forum.
I disagree 100%. That is NOT a good way to work in the forums.
SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
Both also have links to extensive book lists and to (free) on-line chapters
------------------------------------
Reply:
I disagree 100%. That is NOT a good way to work in the forums
+1
~~Bonnie Berent DeWitt [C# MVP]
geek-goddess-bonnie.blogspot.com
------------------------------------
Reply:
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
------------------------------------
Reply:
-1 I think it is good as moderators can propose their own replies as answer like everybody else.
I don't want to be a moderator, their are in my idea better ways. However, I've the idea that own replies marked as answer by moderators don't count anymore; because I see it seldom done anymore. In fact if it does not count there is not any problem as a moderator marks his own reply as answer (Although I would never do it in the case I was an moderator). Be aware a non MSFT/MVP moderator is not direct a subject expert, it is a forum moderator. (The MSFT/MVP part is also not always true, a .Net expert is seldom an Office Expert, but can be an SQL expert (not me).
If own marked answers of moderators still counts then maybe a good suggestion to skip those in the counting system.
:-)
Success
Cor
- Edited by Cor Ligthert Friday, April 20, 2012 4:14 PM
------------------------------------
Reply:
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
- Edited by Naomi N Friday, April 20, 2012 4:19 PM
------------------------------------
Reply:
Naomi,
I thought I forgot something in my message which does affect you, but I was to late to make a correction in my message. Not only MSFT/MVP are experts, many other contributors are as well (including moderators).
Thank you for your reply I think this gives also for the Original Poster (the OP) a good answer on his showed problem.
And sorry if I did offend you (without that you wrote it) in any way.
That was the last I wanted to do, I've very much respect for you.
Cor
- Edited by Cor Ligthert Friday, April 20, 2012 8:31 PM
------------------------------------
SQL 2008 Management issue
System team have decided they will install and create the sql database and provide the individual domain account exclusive to dba's with db read write permissions.
1) They want us to use Sql tools like SQL server management studio ;while it provides many of the development functions I can use, I think that it is not sufficient on its own for the DBA aspect of the work?Without having local admin rights and RDP access to the SQL server; Could you please advise how DBA's manage the databases(backup/resore,performance monitoring) in other companies? and how I can manage the system using SQL management studio only?
2) I think the owner can run the sql 2008 SSIS packages; Can i use my domain account to create,schedule and run SSIS packages, If another DBA in the team needs to run it with his/her own domain account ,can they modify/execute the packages created by me if it requires.?
Please advise.
Thanks
Hsac
Reply:
Hello,
Moderator, this is a duplicate: http://social.msdn.microsoft.com/Forums/en-US/sqlkjmanageability/thread/ce9f7db2-cbb2-4f03-bc6b-8f131df92a35
To answer your questions from my perspective:
As far as the systems team giving DBAs just read or read/write to just the databases and not sysadmin on the server I'm not sure how you're supposed to do your job as a DBA. Without the proper security there is no way to create new logins, check items like procedure cache health, wait analysis, etc.
1. Almost everything I do is either within SSMS, SQLCMD, or powershell. There really isn't a need to RDP to the server unless SQL Server is being installed or certain configuration settings need to be changed, such as enabling protocols. This can be even more intrusive if using SQL Server 2005 with the sac executable. Items like backup/restore/create databases/etc interact with windows under the SQL Server database engine service account. If the account has sufficient rights there if no need for your domain user to have those rights. I have worked in places where we (DBA group) could not RDP to a server at all. This made installing service packs fun for the system team until one went bad... the security policy was re-written and DBAs were given access. Honestly I almost never RDP to a machine unless I am patching it or doing disaster recovery (example: Test your DR documentation by restoring the master database).
2. There are specific roles in the MSDB database for SSIS: http://msdn.microsoft.com/en-us/library/ms141053(v=sql.105).aspx
How those SSIS packages are written and what interaction with the operating system that is needed will have to be discussed internally with your team.
Hopefully this helps,
Sean
------------------------------------
Reply:
Hi Thanks for your reply,
Could you please advise on the below questions as well:
1) How can I schedule a batch job in windows control panel without RDP to server?
2) How can I restore the database or refresh the test system without having the access to the shared disk drive on the server?
3) How can i use performance monitoring tools (database engine tuning advisor,sql profiler etc)from server?
4) Who will look after database installation/upgrades?
5) If server administrators create the database and assign the login details then who will be responsible for the database security?
Thanks
hsac
------------------------------------
Reply:
Hsac,
1. There shouldn't be a need to schedule using Windows Task Scheduler, if possible Agent should be used which resides with SQL Server. If you would need to have a windows task put in, I'm assuming you would want to put in a change control and then one of the system admins would create the task. Other than a few express editions I have yet had the need to create a windows task for anything SQL Server related.
2. Backup and Restore use the database engine service account as the windows security principal. If the service account has access (or is given access) to said shared drives there should be no need for your domain account to have access. On the other side of the coin, if there is a time when the service account doesn't have access or something prohibits authenticated access to the network (such as local account), your domain account may need the rights to copy/move files in their respective locations.
3. To run profiler on the server, don't use the GUI, run a server side trace. The easiest method to do this is to fire up profiler on your local machine, create the trace definition you are looking for, initiate the trace (*), immediately stop the trace, then export the trace definition.
For the DTA, you can use the server side trace to capture the workload and ask one of the system admins to give you the workload file, then run DTA from your desktop. While this isn't necessarily ideal, you really shouldn't be running DTA against a production server so I find the added network talk minimal.
*: In your original post, it was pointed out that you don't have server level permissions. This may conflict with server level tuning. For permissions needed to run a trace: http://msdn.microsoft.com/en-us/library/ms187611.aspx
4. As of now it seems your system admins will. IMHO you need to sit down with your manager and the manager of the system admins team and discuss duties. If someone gave me read only access to a single database and told me to do my normal DBA functions I would laugh at them and walk away. Granted there are a good many things you can do with restricted access, but not even being able to check account permissions (such as in an audit of a user or application) means you can't do your job (if that falls under you).
Probably the best thing you can do, again it's my opinion, is to write down everything you don't have access to and ask the system admins (copy their manager and yours) to do them for you, give them the scripts and what time/when the need run and how often they need run. They'll either do it and you can do your job or they'll moan and you'll get access. Either way, you win.
5. See #4. This once again would fall under them as they are the only ones with permissions to do so. The only other way to accomplish this is to write the scripts and send it to them with schedules, etc.
-Sean
------------------------------------
Reply:
Thanks for your reply. much appreciated.
I have got the answers of above questions.:)
Please advise if there is any way to monitor event viewer application logs without access to server? and also
do i need Business intelligence development studio license separately to create ssis packages from my workstation?
Kind Regards,
Thanks
------------------------------------
Reply:
Hello,
If given permission to do so, you could use the windows event viewer and connect to the remote PC. That is a windows level permission and is outside of SQL Server. If you are referring to the log file viewer in SQL Server (for agent logs and engine logs) that is actually inside of SQL Server but you'll need SA level permissions to do so (it can also be done remotely).
As far as BIDS goes, I don't believe the studio needs licensed but I'm just guessing. You'll want to call a microsoft licensing specialist to get the correct information on that.
-Sean
------------------------------------
Reply:
Hi ,
Thanks for you all the replies.We had a meeting with server team and they advised us the below :
Server Team will create a new domain group for DBA and also will provide the access to SQL DB folder access to DBA group and DBA can access the folder by clicking on the shortcut from their workstation. But no RDP to server will be provided
Server team will schedule the batch jobs if it required.
The SQL DB installation is server team's responsibility and DB Upgrades and applying the DB SP is DBA's responsibility.
Event viewer access will not be provided to DBA
Server team will install Sql server on server by using DBA domain group.
sysadmin DB rights will be provided to DBA.
Do you think DBA will be able to fulfill our responsibilities if we have given the above access?
Is this the secure way to manage the sql database?
Thanks
Hsac
------------------------------------
Reply:
Hsac,
You could manage the databases this way, but there are two things that really bug me.
The first is that the server team is going to install SQL Server, but there is no mention of a standards document that will be followed. This is important as the server team will be installing SQL Server and there is nothing that they are going to follow when they install it. Where should it be installed, what options should be chosen, local account or domain account? etc.
The second question is how are you supposed to apply database service packs when you don't have rdp access? I don't understand that one... either the nomeclature is incorrect or the process is not understood.
-Sean
------------------------------------
Reply:
Hi,
Server team are not willing to provide the rdp to dba's that's why they are finding alternative ways to the above issues. Server team is taking the responsibility of database installation and upgrade. Please advise if all the DBA's responsibilities be performed without rdp? how dba's work on cloud environment? what are Microsoft's recommendations?
Thanks and Regards.
Hsac
------------------------------------
Reply:
If you don't have access to the server, a document must (even if you have access it should be created) be made to hand to your server team. It should have exactly how to install SQL Server, including all options needed, paths, etc. The alternative would also be to give the server team a configuration file and have them run the setup with the given config (which is the same thing as an answer file).
If the server team is going to be responsible for patches and upgrades, let them do it. If something goes awry and they have to contact you, that's just more time to take in a resolution - they may not meet their SLA and the fallout could bring rdp access to you, never know.
In the cloud you generally don't have access through rdp. The host will do upgrades as needed (generally) or in the case of Azure hosting all you have is access through sql server. When dealing with cloud environments as much scripting as possible is generally needed, but not a must as most tasks are taken care of by the hosting provider behind the scenes.
-Sean
------------------------------------
Reply:
Hi Sean, Thank you very much for reply.
I had a meeting with server team today and they had installed sql server with administrator and windows admin login. They have created databases for another services and they asked me to create my database in the same instance. I have checked the sql security logins and the number of logins were already there with sysadmin rights and server team is managing sql logins. I have requested them to create a separate named instance(if they are not going to provide me rdp) exclusively for my application by using dba roles that i would be responsible. They told me dba will get an access to one folder on server and the shortcut that folder will be created on DBA's workstation.Please advise if this is the right way to proceed? How we can move the files on server if we move on cloud? Can you please advise DBA's responsibilities to manage the server hosted on cloud?
Thanks and Regards
Harinder
------------------------------------
Reply:
Harinder,
If a cloud solution is used, most places you will not have access to files or folders on the server. For example, let's look at the Azure hosting from Microsoft.
You would not have any access to the server, your entire access would be through a sql login to the service. Files would not be able to be uploaded or downloaded and all logins would need to be sql logins (as windows logins depend on your domain which does not exist there). Backups would not be able to be done or brought down from the cloud, however the data could be synchronized to a local database and then a backup taken and shipped to say a 3rd party vendor who needs it to do troubleshooting.
http://www.windowsazure.com/en-us/home/features/sql-azure/
Other than a few certain situations (backup file to vendor, etc) I never need to rdp or even access a single folder on the remote server. With a sysadmin level login, almost everything that is needed to be done can be done through ssms or some other tool (SQLCMD, etc) that provides connectivity.
If your server team is responsible for logins, I await the first time they have to do a security access audit - that should be an exciting time for them.
-Sean
------------------------------------
Remove numbers from the text
I have table like id name
1 123sagar
2 Raju456
But i want out table like
id name
1 sagar
2 Raju
Please help me with this scenario
Reply:
I would use the Script component. I would do a regular expression replace:
System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex("\\d"); public override void Input0_ProcessInputRow(Input0Buffer Row) { Row.Name = reg.Replace(Row.Name, ""); } Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008
------------------------------------
Reply:
You can use the below TSQL to update your table.Give your table name in YOURTABLENAME in the TSQL.
declare @name nvarchar(50) declare @i int declare @id int declare @cursor_table as cursor set @cursor_table= cursor for select id,name from msdn1 open @cursor_table fetch next from @cursor_table into @id,@name while @@Fetch_Status=0 begin set @i=0; while @i<10 begin set @name = replace(@name,''+@i+'',''); set @i=@i+1; end update YOURTABLENAME set name = @name where id=@id ; fetch next from @cursor_table INTO @id,@name end close @cursor_table deallocate @cursor_table
------------------------------------
Self-Service Password Reset (SSPR) Resource Wiki
At the request of a co-worker, we felt the need to create a Self-Service Password Reset Landing Page. Here it is.
Self-Service Password Reset (SSPR) Resource Wiki: http://social.technet.microsoft.com/wiki/contents/articles/9846.self-service-password-reset-sspr-resources.aspx
Timothy P Macaulay, MCSD, MCSD.NET, MCAD, MCP
sugestion, new way of writeing.
i not a Tech or Specialist so i not even sure if posable
why do Microsoft makes Windows like the following?
Windows System files, into a Packed File (like a zip)
reason, windows have a HUGH amount of small files, small files reduce read speed, also the more files
the more easy to hack or having security loops and a higher chance of data corruption
with a single (zip) read only file, for instance 1024 byte and it's gets 1023 bytes, the windows will know it's hacked.
if not protected with a data compressor
Normal Data encrypted data, in Compressed file
User Windows
Computer Normal Data (backup) vanilla
System information/drivers
Reg, and other critical files
-----------------
Read/write information
Reply:
Hi,
Not really sure what you want but an anti-virus can keep your computer and data secure from attacks because you can scan data on a schedule, but most importantly they now generally actively scan data being executed etc which ensure nobody is attacking your data or computer.
Other than windows zip, you could use 7zip or winrar to keep your data compressed and secure, of which are both free which is even better.
hope it helps.
Lewis.j.Routledge
------------------------------------
SP2010 Workspaces - Use Cases/Security Concerns?
Couple of days back I posted Comparison of Workspaces in SharePoint WorkSpace 2010 in the technet gallery, which includes comparison of the use case scenarios and Security aspects of various workspaces in SharePoint Workspace 2010 product. This particular presentation was compiled mostly based on product's published capabilities at various sources and my limited experience with workspaces as content consumer/IT professional.
If you've used SharePoint Workspace 2010 to solve some real life business problem(s) or encountered some security issues/concerns or can think of more use cases/security scenarios, I would love to hear from you
- Edited by Sanjeev.Gupta Friday, April 20, 2012 1:32 PM
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
SP2010 Workspaces - Use Cases/Security Concerns?
Couple of days back I posted Comparison of Workspaces in SharePoint WorkSpace 2010 in the technet gallery, which includes comparison of the use case scenarios and Security aspects of various workspaces in SharePoint Workspace 2010 product. This particular presentation was compiled mostly based on product's published capabilities at various sources and my limited experience with workspaces as content consumer/IT professional.
If you've used SharePoint Workspace 2010 to solve some real life business problem(s) or encountered some security issues/concerns or can think of more use cases/security scenarios, I would love to hear from you- Edited by Sanjeev.Gupta Friday, April 20, 2012 1:24 PM
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
SCCM Collection query providing computers with specific Malware Infection
Hi,
I am trying to source for a collection query concerning my environment, my scernario first is this:
1. SCCM 2007 R3 Primary Site Server
2. Forefront Endpoint Protection 2010 also installed in the same server (Intergrated with SCCM)
Now my question is how can I make a query for a Collection generating the computers with the Specific Malware infection for example W32/Sality.Viru, as a current default all reports and collections made by FEP is by defualt read only.
But since the SCCM and FEP is integrated computers with specifi Malware infection can be quiried but since I am not an sql guy then if any once can help me?
Regards,
Reply:
if it is specific file or exe ,you can try to find that by enabling software inventory option and then create collection based on the file name.
http://eskonr.com/2011/05/sccm-report-to-inventory-file-types-like-pst-ost-sft-etc/
else if you are looking for application installed or not,try with default report avilable computers with particular add and remove programs.
Please click on "vote as Helpful" if you feel this post helpful to you.
Eswar Koneti | My Tech blog: www.eskonr.com| Linkedin: Eswar Koneti
- Edited by Eswar konetiMVP Sunday, February 19, 2012 2:00 PM
------------------------------------
Reply:
Hi Arnel,
As far as I am aware, FEP reporting cannot be done with that kind of granularity.
You can run a report based on Add Remove Programs, I dont think this will suit your needs though.
You can run reports on specific files, however, you have to specify that this information be collected before you can report on it - it's not overly efficient, and probably not that effective.
Ask the people over in the Forefront Technet Forums perhaps?
Cheers.
------------------------------------
Reply:
Hi Arnel,
As far as I am aware, FEP reporting cannot be done with that kind of granularity.
You can run a report based on Add Remove Programs, I dont think this will suit your needs though.
You can run reports on specific files, however, you have to specify that this information be collected before you can report on it - it's not overly efficient, and probably not that effective.
Ask the people over in the Forefront Technet Forums perhaps?
Cheers.
Dear Adrian,
This is what I also think at first, it took me 4 hours just for searching about this special procedure but to no avail, your right "granularity" is the right term for this settings which unfortunately maybe the Microsoft Forefront team will .
To add up to my scenario, I can pinpoint infected machines through FEP report, now to segragate this computers to a collection through Querying (to save me time adding machines manually) and apply necessary patches is the whole idea.
Thank you for understanding my requirement, although a "long shot" (Another set of procedure required) that might possible work is also suggested by Eswar.
Also thank you for Mr. Eswar regarding the suggestion.
------------------------------------
Reply:
Arnel-101 I would avoid running SCCM as your malware scanner. Get Forefront/MSE and let a proper tool do the work.
This is an example of a report written by a junior I know, it works, but don't count on your server doing much while it's generating it. It will cripple your reporting server and more than likely push all the other reports batched out of the way. So word to the wise. Use at your own risk.
SELECT DISTINCT RSYS.Name0 As 'Computer', BI.SerialNumber0 As 'Serial Number', RSYS.User_Name0 As 'Last User ID', SF.FileName As 'File Name', SF.FileDescription As 'File Description', SF.FilePath As 'File Path', SF.FileSize As 'File Size', SF.FileVersion As 'File Version' FROM V_R_SYSTEM RSYS INNER JOIN V_GS_SoftwareFile SF ON RSYS.ResourceID = SF.ResourceID INNER JOIN dbo.v_GS_PC_BIOS BI ON RSYS.ResourceID = BI.ResourceID AND SF.FilePath not like '%Research In Motion%' /*RIM Software*/ AND SF.FilePath not like '%\VMware%' /* VMware Network sniffer*/ AND SF.FilePath not like 'C:\Program Files\Hummingbird%' /* Hummingbird tool to configure the NIS */AND ( SF.FileDescription like '%doom%' OR /* DOOM Game */ SF.FileDescription like '%GNUTE%' OR /* MP3 Resources */ SF.FileDescription like '%l0pht%'OR /* Password cracker */ SF.FileDescription like '%keylog%'OR /* Key logger */ SF.FileDescription like 'Lime%' OR /* Peer-to-Peer file sharing */ SF.FileDescription like '%nuke%' OR /* DOOM Game */ SF.FileDescription like '%orafice%' OR /* Keystroke mapper */ SF.FileDescription like '%sniff%' OR /* Network sniffer */ SF.FileDescription like '%unreal%' OR /* Games */ SF.FileName like '%as-101%' OR SF.FileName like '%babylon%' OR --SF.FileName like '%bindin%' OR SF.FileName like '%azure%' OR /* Torrent Client */ SF.FileName like '%bitt%' OR /* Torrent Client */ SF.FileName like '%bo2k%' OR SF.FileName like '%BitComet%' OR /* Torrent Client */ SF.FileName like '%chknull%' OR SF.FileName like '%Crack%' OR /* Password cracker */ SF.FileName like '%Cracker%' OR /* Password cracker */ SF.FileName like '%Craserv%' OR SF.FileName like '%desktop.exe' OR SF.FileName like '%doom%' OR /* DOOM game */ SF.FileName like '%EbatesMoeMoney%' OR /* Spyware */ SF.FileName like '%expolit%' OR SF.FileName like '%exploit%' OR SF.FileName like '%FROST%' OR /* Peer-to-Peer file sharing */ SF.FileName like 'gator%' OR /* Gator Spyware/Adware */ SF.FileName like '%getadmin%' OR SF.FileName like '%GROK%' OR SF.FileName like '%hack%' OR /* Password cracker */ SF.FileName like '%hotbar%' OR /* IE Toolbar - Spyware/Adware */ SF.FileName like '%kazaa%' OR /* Peer-to-Peer file sharing */ SF.FileName like 'keylog%'OR /* Password cracker */ SF.FileName like 'keygen%'OR /* Password cracker */ SF.FileName like '%l0phtcrack%' OR /* Password cracker */ SF.FileName like '%lc252install%' OR /* Password cracker */ SF.FileName like '%LIME%' OR /* Peer-to-Peer file sharing */ SF.FileName like '%GAMES%' OR /* Games file */ SF.FileName like '%morpheus%' OR SF.FileName like '%Napster%' OR /* Peer-to-Peer file sharing - MP3 Resources */ SF.FileName like '%nbsvr%' OR SF.FileName like '%nbtscan%' OR SF.FileName like '%ndssnoop%' OR SF.FileName like '%netbusr%' OR SF.FileName like '%nmapNT%' OR SF.FileName like '%nuke%' OR /* DOOM Game */ SF.FileName like '%nwpcrack%' OR SF.FileName like '%orafice%' OR /* Keaystroke mapper */ SF.FileName like '%otglove%' OR SF.FileName like '%pwdump%' OR /* Password cracker */ SF.FileName like '%quake%' OR /* DOOM game */ SF.FileName like '%Retina%' OR SF.FileName like '%RFPoison%' OR SF.FileName like '%smbdie%' OR SF.FileName like '%smurf%' OR SF.FileName like '%torrent%' OR /* Torrent Client */ SF.FileName like '%unreal%' OR SF.FileName like '%XUPITER%' OR SF.FileName like 'POPSRV%' OR SF.FileName like '%VUZE%' OR /* Torrent Client */ --SF.FilePath like '%My Shared folders' OR /* Shared Folders for P2P */ SF.FileName IN ('_DLL.exe', /* Troj_Bagle.AC Trojan */ 'ARR.exe', /* Dial-up Hijacker - high cost toll number */ 'asart.exe', /* ? */ 'av.exe', /* W32.Alphx.Word.A Virus */ 'BackWeb.exe', /* Spyware - BackWeb Technologies */ 'Bargains.exe', /* BargainBuddy - Adware/Spyware */ 'BELT.exe', /* Spyware - SearchV.com */ 'Bling.exe', /* W32.SDBot-OH.Worm */ 'BLSS.exe', /* Spyware - CBlaster Trojan */ 'Bootconf.exe', /* Sypware - Homepage Hijacker */ 'BonziBdy.exe', /* Spyware */ 'botzor.exe', /* W32.ZOTOB.Worm */ 'BPC.exe', /* Spyware - Grokster */ 'Bundle.exe', /* Adware.SAHAgent */ 'businessbg0002.exe', /* Spyware - ? */ 'cmesys.exe', /* Adware.W32.Claria */ 'crafty.exe', /* ? */ 'CFD.exe', /* Spyware - Motive Cleint Foudation */ 'csm.exe', /* W32.ZOTOB.B Worm */ 'Datemanager.exe', /* Pop-Ups via Gator */ 'DIVX.exe', /* MASTAK Virus or NALDEM Trojan */ 'DPPS2.exe', /* Don't Panic! Pop-up blocker - Spyware */ 'DSSagent.exe', /* Adware - Broderbund - Spyware? */ 'eanthology.exe', /* eAcceleration Software Station - Spyware? */ 'EditSRV.exe', /* Spyware - Email_Update.exe */ 'email_Update.exe', /* StopSign Email Scanner - eAcceleration Software - Spyware? */ 'EMSW.exe', /* Spyware - Alset Inc. */ 'Gator.exe', /* Adware.W32.Claria */ 'gmt.exe', /* Adware.W32.Claria */ 'haha.exe', /* Myet Trojan */ 'Hbinst.exe', /* Spyware - HotBar */ 'HBSRV.exe', /* Spyware - HotBar */ 'Hotbar.exe', /* Spyware - HotBar */ 'HXDL.exe', /* HXDL Spyware - Gator */ 'HXIUL.exe', /* Adware - HelpExpress - Alset Inc. */ 'IDHost.exe', /* Topicks Spyware */ 'IEDll.exe', /* Homepage Hijacker */ 'IEDriver.exe', /* Peer-To-Peer File Sharing */ 'INFUS.exe', /* Dial-up Hijacker - high cost toll number */ 'InfWin.exe', /* MSView Parasite */ 'INTDEL.exe', /* Adware - Pop-ups */ 'ISTSVC.exe', /* Spyware - Integrated Search Technologies */ 'KeenValue.exe', /* Spyware - Gator */ 'loader.exe', /* Backdoor.Prorat Virus */ 'lol.exe', /* W32.HLLW.Rackus Virus */ 'Lspmonitor.exe', /* Spyware - StopSign */ 'mapisvc32.exe', /* KX Virus */ 'MD.exe', /* System MD Virus */ 'MDie.exe', /* Backdoor.Win32.Rbot.Gen Virus */ 'MemoryMeter.exe', /* Grokster Peer-To-Peer File Sharing Suite */ 'MFIN32.exe', /* Adware - MyFreeInternet Update */ 'MMod.exe', /* Adware.W32.EarnBundleWare */ 'MOStat.exe', /* Spyware - Wurld Media */ 'mousebm.exe', /* W32.ESBot Virus */ 'mousemm.exe', /* W32.ESBot.A Virus */ 'MSBB.exe', /* Adware.W32.BargainBuddy - 180Solutions */ 'MSCache.exe', /* Spyware - Integrated Search Technologies */ 'MSCMan.exe', /* Spyware - Odysseus Marketing */ 'msdefr.exe', /* Spybot Worm */ 'MSMACROPROTXZ.exe', /* Spybot Worm */ 'MSMGT.exe', /* Spyware - Total Velocity */ 'MSSVR.exe', /* Spyware - 2020DownLoader - 2020 Internet Search Toolbar */ 'MSUpdater.exe', /* TrojanDownLoader.Win32.WinShow Trojan */ 'MWSOEMON.exe', /* MyWebSearch Toolbar */ 'mwsvm.exe', /* Adware - Adw.ScanPortAL.A */ 'Nail.exe', /* Trojan.Win32.Stervis.B Trojan */ 'nb32ext2.exe', /* MyDoom.BV worm */ 'nbmanager.exe', /* Spyware - eAnthology */ 'netbutler.exe', /* ? */ 'onsrvr.exe', /* Spyware - OnWebMedia */ 'PC32.exe', /* Mastak Virus */ 'per.exe', /* Worm.ZOTOB.C Virus */ 'PGMonitr.exe', /* Adware.W32.DelFin */ 'PowerScan.exe', /* Adware.W32.PowerScan */ 'PRMVR.exe', /* Spyware - Adtomi.com */ 'pnpsrv.exe', /* W32.SDBOT.Worm Virus */ 'Precisiontime.exe', /* Adware.W32.ClariaPrecision */ 'PrizeSurfer.exe',/* Spyware - PrizeSurfer */ 'Prmt.exe', /* Spyware - OpiStat */ 'RAY.exe', /* Homepage Hijacker */ 'RB32.exe', /* Adware.W32.RapicBlaster */ 'RCSync.exe', /* Spyware - PrizeSurfer */ 'Run32DLL.exe', /* Key Recorder - Screen Capture - PAL PC Spy */ 'SAHAgent.exe', /* Adware.W32.CyDoor - CyDoor Desktop Media */ 'savenow.exe', /* Coupons - WhenU.com */ 'SBHC.exe', /* IE Plugin - GIGATech Software */ 'ShowBehind.exe', /* Adware - MicroSmarts Enterprise */ 'SLMSS.exe', /* Spyware - 2nd Thourgh by CPM Media */ 'SRNG.exe', /* Spyware - Search Hijacker */ 'STCLoader.exe', /* Spyware - 2nd Thourgh by CPM Media */ 'SUSP.exe', /* Spyware - ABetterInternet */ 'SVCINIT.exe', /* Backdoor.Sinit Trojan */ 'svnlitup32.exe', /* Worm.RBOT.CBJ */ 'syscpy.exe', /* Backdoor.Hogle Trojan */ 'Systesm32.exe', /* Spyware - Bling.exe */ 'thefourthcoming.exe', /* ? */ 'Trickler.exe', /* Spyware - Gator GAIN (Gator Advertising and Info Network) */ 'TSADBot.exe', /* Adware */ 'TVMD.exe', /* Spyware */ 'TVTMD.exe', /* Spyware */ 'UCMWESKU.exe', /* ? */ 'Updates32.exe', /* Spyware - Bling.exe */ 'uptodate.exe', /* Adware - BrowserPal */ 'veloz.exe', /* StopSign Email Scanner - eAcceleration Software */ 'velozsys.exe', /* StopSign Email Scanner - eAcceleration Software */ 'Weather.exe', /* Adware */ 'webcel.exe', /* eAcceleration Software - Spyware - ? */ 'WebDev.exe', /* ? */ 'Win32US.exe', /* Dial-up Hijacker - high cost toll number */ 'WinActive.exe', /* Homepage Hijacker */ 'windrg32.exe', /* W32.ZOTOB.D Worm */ 'WinMain.exe', /* Trojan.KonDeli */ 'WinNet.exe', /* Adware/Spyware - CommonName I.E. Search */ 'winpnp.exe', /* W32.SDBOT.Worm */ 'WinServN.exe', /* Adware.W32.PurityScan - ClickSpring LLC */ 'WinStart.exe', /* Homepage Hijacker - iGetNet */ 'WinStart001.exe', /* Adware */ 'wintbp.exe', /* W32.ZOTOB.E Worm */ 'wintbpx.exe', /* W32.BOZORI.Worm.B */ 'WNAD.exe', /* Spyware - TwistedHumor.com */ 'wpa.exe', /* ESBOT Worm */ 'ygpmrgsb.exe', /* ? */ 'zeus.exe', /* Zeus:Master of Olympus game */ 'zmanager.exe' /* Spyware - eAcceleration */ ) )ORDER BY --RSYS.Name0 RSYS.User_Name0, SF.FileName
------------------------------------
Reply:
Hi there
The FEP Reporting Database is not the same database as the SCCM one. For this reason I would think it extremely unlikely that you'd be able to build a collection of systems showing a particular infection.
It's a good request though and I think you should raise that as a DCR with Microsoft.
I don't have a console in front of me but I *think there is a collection of infected systems. You could deploy to that and over-hit
------------------------------------
Hyper-V Cluster lost CSV Volume, no partition on Volume
I would like to know if anybody has experienced the same situation.
I have a Hyper-V Cluster running on three Blades on a BladeCentre Chassis S with a SAN presented via the SAS Raid Controllers.
LUNS are presented to the Hyper-V Cluster Hosts and validation of the cluster is successful. I have been running this configuration for approximately two years now with no problems.
Two days ago I started a backup of a new Virtual Machine and during the snapshot operation one of the Volumes containing the CSV Volume for the Virtual Machines was put into redirected access. The backup was started in the evening and the software used is Backup Exec 2010 R3.
I have had no issues or problems with backing up virtual Machines. (BOLD)
The following morning, three hours into the day we realised that we had issues on the Cluster as Virtual Machine services was unresponsive. Further investigation revealed that the backup Job had hung and had put the Volume into redirected access. We stopped the backup Exec job engines and the Backup Job failed.
The redirected access was cleared on the volume, but with a missing CSV Volume and the VM's in the LUN started going offline with missing resources. We checked the Storage and all volumes were online and presented to the hosts. When we tried to assign the volume for CSV access, it failed. Reason being that there was not NTFS files system to complete the operation. Disk Management reported that the disk had to be initialised, which we eventually did. After that we reformatted the Volume, created the CSV and restored the missing VM's back into the Cluster Shared Volume from backup.
All Blades running Windows Server 2008 R2 (SP1), fully patched and all updates and hotfixes installed to address potential issues during cluster validation.
My suspicion is that the amount of time that the Volume was in redirected access (approximately 20 Hours) and the snapshot (backup) that was in progress corrupted the partition on the volume but I need to confirm this.
Comments and suggestions is welcome.
- Edited by Mufassa29 Friday, April 20, 2012 10:08 AM
Reply:
Without further investigation, it's hard to tell the cause of the issue.
By the way, did you get any errors in Event Viewer about Hyper-V, Cluster and storage?
Vincent Hu
TechNet Community Support
------------------------------------
Reply:
Hi Vincent
General errors on VMMS complaining about not being able to refresh resources, and that IO has been redirected and all operations has been paused. I'm currently investigating if there is any active filters that could have caused the issue. This is the first issue I've had with a Hyper-V cluster. Never lost a Volume or Virtual Machine on any of our customer sites. We have customers that run VMware and Hyper-V cluster and we've had downtime on the several VMware Cluster's and VMware Virtual Machines.
We have Hyper-V cluster's thats been up for more than a year and a half and hosts are put in maintenance mode to install updates etc. Where we have had downtime is on storage arrays that need Firmware upgrades etc. We even Run Sun Solaris 64 Bit on our Clusters but thay stay on one host with no migration
We had an issue about three years ago where a customer installed a Netbackup agent on a server and during the Backup the job froze as well. The Server stayed on line but became increasingly unresponsive so they decided to reboot it and all hell broke loose. Turned out that the partitions on the RAID array was corrupted.
Still stumped
------------------------------------
Reply:
Best regards
Joachim Nässlander
MVP Cluster
Member of Microsoft Extended Experts Team (MEET)
Blog: http://www.nullsession.com
------------------------------------
No comments:
Post a Comment