MSSQL 2014: Log Backup Failed to Complete Rule Functionality
Hi everyone,
i ran into a issue with the Rule MSSQL 2014: Log Backup Failed to Complete in the SQL Server 2014 (Monitoring) MP 6.7.15.0 Maybe it applies to previous MP Versions or other Rules from different MPs....i don't know, just noticed it today.
Now here's my issue:
The rule throws an alert when a Logfile Backup was not completed. The rule looks in the Application Log for Event ID 3041 and via RegEx after the words BACKUP and LOG. This works fine but if the description changes e. g. the Name of the Logfile, there is no new alert on this. The repeat Counter just goes up instead. So if two different Logfiles fail to backup i will only recieve one alert within SCOM showing me the latest Event that was written to the Application Log. There should be a functionality "Generate new alert if Logfile Name changes" :-)
Anyone else having this issue or could give me some hints how to solve this? Thanks in advance...
Parent child hierarchy reset values
Hello everyone,
I have a task, where I could need some starting support.
I built a cube which aggregates the sales amount with a parent child hierarchy. I have nodes in that hierarchy which are two times in the hierarchy as you can see it in the pic (node 3). Of course the ID in the background is different.
Additional information to the task
- The amount of node 3 included the childs of are every time the same
- Depending on the value of node 3 I need to reset the value for node 3 and every child. if node 3 is greater or equal 0 it should be reset to 0 for path 1-2-3. If it is smaller then 0 I need to reset the path 5-3
- In addition the reset amount should not be included into the parent levels (see the following pic)
- As the amount and the localization depends on filter of the dimension attributes I need to do it in mdx.
The following pic presents the case, that node 3 is greater or equal 0.
Looking forward to read from you!
Thanks Andy
- Edited by Bandi_162 Tuesday, December 20, 2016 9:41 AM
Reply:
Hi,
u could think of using CustomRollupFormula and the define the formula in the source. Be aware of Performance.
Kr
------------------------------------
Reply:
Hey yger,
thanks for your reply.
I am trying to work with scope assignments. But its the same with the performance problem i think :-)
Best AB
------------------------------------
Need to know higher end version
Hi,
I am running a small scale industry. I would like to purchase visual studio 2010. In that i have idea of purchasing higher end version between Visual studio 2010 Premium and Visual studio 2010 professional.
PLS SUGGEST.ASAP.
Thanks in Advance.
Remote Desktop Mac colors way off
The hues on a remote session, at least on the Mac app, seems to be pretty off. My quality settings are on the highest too.
Reply:
Hi,
Thanks for your feedback.
We will keep on improving the product and user experience.
Best Regards,
Alvin Wang
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
Always on latency problem
Hi, I have two databases and one of them does not sync (high latency) on specific server. All have the same disk, memory, and so on. All in internal network. What can I do to identify why this occurs in this specific case? (He has no workload at present). It would not be the network, because the first DB has much more data than what is delaying. Thank you very much
(i try send a print, but do not work)
- Edited by Carmona, Diego Tuesday, January 24, 2017 9:32 PM
Reply:
Are they in the same AG?
Anything interesting in SQL Server log and availability group health events?
------------------------------------
Reply:
Hi,
Please could let us know how you monitoring the AG latency?
Can you use below query on Primary and provide output for further analysis?. This query will provide current latency information.
SELECT AGS.NAME AS AGGroupName ,AR.replica_server_name AS InstanceName ,HARS.role_desc ,DRS.synchronization_state_desc AS SyncState ,DRS.last_hardened_time ,DRS.last_redone_time ,((DRS.log_send_queue_size)/8)/1024 QueueSize_MB ,datediff(MINUTE, last_redone_time, last_hardened_time) as Latency_Minutes FROM sys.dm_hadr_database_replica_states DRS LEFT JOIN sys.availability_replicas AR ON DRS.replica_id = AR.replica_id LEFT JOIN sys.availability_groups AGS ON AR.group_id = AGS.group_id LEFT JOIN sys.dm_hadr_availability_replica_states HARS ON AR.group_id = HARS.group_id AND AR.replica_id = HARS.replica_id
Thanks,
Kindly mark the reply as answer if they help
------------------------------------
MS Visio Pro Office 365
I have purchased Ms Visio pro office 365 but i am not able to use it on multiple system
Getting error while installing the Visio software in MAC and other devices.
Adaptec AHA-2940 SCSI card and Windows 10
I have a Windows 7 system and a scanner connected to an ADAPTEC AHA-2940 SCSI card. This scanner is a pre-press professional scanner and there are no other scanners available of the same quality.
I would like to update to Windows 10 but I am not sure if Win 10 is compatible with this SCSI card.
So my question is Has anyone managed to get this card working under a Win 10 environment?
Your help is much appreciated.
Reply:
------------------------------------
Windows Update is being shutdown for new portal
There are a number of clear impacts.
Read this article for impacts and the new method (RESTfull API) of accessing bulletins.
https://redmondmag.com/articles/2017/01/13/microsoft-replacing-security-bulletins-portal.aspx
MSRC Portal: https://portal.msrc.microsoft.com/en-us/security-guidance
Code samples:
#Get the Updates as XML Invoke-RestMethod -Uri 'https://api.msrc.microsoft.com/Updates?api-Version=2016' -ContentType application/xml -Headers @{'Api-Key'='{api key}'} #Get the Updates as JSON Invoke-RestMethod -Uri 'https://api.msrc.microsoft.com/Updates?api-Version=2016' -ContentType application/json -Headers @{'Api-Key'='{api key}'} #Get the CVRF with ID 2016-Nov as XML Invoke-RestMethod -Uri 'https://api.msrc.microsoft.com/cvrf/2016-Nov?api-Version=2016' -ContentType application/xml -Headers @{'Api-Key'='{api key}'} #Get the CVRF with ID 2016-Nov as JSON Invoke-RestMethod -Uri 'https://api.msrc.microsoft.com/cvrf/2016-Nov?api-Version=201'6 -ContentType application/json -Headers @{'Api-Key'='{api key}'} \_(ツ)_/
- Edited by jrv Tuesday, January 24, 2017 8:54 PM
Windows Update is being shutdown for new portal
There are a number of clear impacts.
Read this article for impacts and the new method (RESTfull API) of accessing bulletins.
https://redmondmag.com/articles/2017/01/13/microsoft-replacing-security-bulletins-portal.aspx
MSRC Portal: https://portal.msrc.microsoft.com/en-us/security-guidance
Code samples:
#Get the Updates as XML Invoke-RestMethod -Uri 'https://api.msrc.microsoft.com/Updates?api-Version=2016' -ContentType application/xml -Headers @{'Api-Key'='{api key}'} #Get the Updates as JSON Invoke-RestMethod -Uri 'https://api.msrc.microsoft.com/Updates?api-Version=2016' -ContentType application/json -Headers @{'Api-Key'='{api key}'} #Get the CVRF with ID 2016-Nov as XML Invoke-RestMethod -Uri 'https://api.msrc.microsoft.com/cvrf/2016-Nov?api-Version=2016' -ContentType application/xml -Headers @{'Api-Key'='{api key}'} #Get the CVRF with ID 2016-Nov as JSON Invoke-RestMethod -Uri 'https://api.msrc.microsoft.com/cvrf/2016-Nov?api-Version=201'6 -ContentType application/json -Headers @{'Api-Key'='{api key}'} \_(ツ)_/
- Edited by jrv Tuesday, January 24, 2017 8:54 PM
bginfo has some multi-monitor bugs.
Here are the bugs in the current version of bginfo that we have found so far.
1. It does not account for multiple monitors being able to have the taskbar enabled. For the monitor it detects as the main monitor it will offset the information in order to not have the taskbar over top of it. On the other monitors it does not, so it can potentially cut off part of the information and also makes it not uniform.
2. In a 3 monitor setup it thinks that monitor #2 is the main monitor. It appears to not be checking what monitor is actually set to be the main monitor.
New Community App-V Recipe List
In collaboration with Aaron Parker, I went ahead and took his excellent list of community App-V recipes and separated them out into two lists. One for App-V 4.x and the other for App-V 5.x. This list is hosted on github, which means anybody can make a change, it will get to me to approve. I can approve, accept the change and your contributed recipe will appear.
The current App-V 5.x list can be found here: https://rorymon.github.io/appvrecipes/
The App-V 4.x list can be found here: https://rorymon.github.io/legacyappvrecipes/
PLEASE MARK ANY ANSWERS TO HELP OTHERS Blog: rorymon.com Twitter: @Rorymon
App-V 5.0 Recipe: FileZilla
Application Name: FileZilla
Application Version: 3.8.0
Company Name: Filezilla-project.org
Sequencer Version: 5.0 SP2, 5.1
App-V Client Version Tested On: 5.0, 5.0 SP1, 5.0 SP2, 5.1
**Install to PVAD for versions 3.22.1 and newer**
Operating System Sequenced On: Windows 7 (32bit)
Pre-requisites: None
Client Operating Systems Successfully Deployed To: Windows 7 (32 and 64bit), Windows Server 2008 (32 and 64bit)
*Posted by non-Microsoft Employee: Cody Lambert
If Posted by Microsoft Employee, the Corresponding KB Article Reference: N/A
Steps to Sequence the Application:
- Start sequencing > Create Package (default) > Standard Application (default) > Select the installer for the application
- Package Name: FileZilla 3.8.0 (or however you wish to name it)
- Primary Virtual Application Directory: C:\FileZilla
- Destination Folder for Installation: C:\FileZilla (when you click next, it will change this to C:\FileZilla\FileZilla FTP Client)
- Choose defaults for the rest of the installation, but un-check the box for "Start FileZilla now" and click Finish
- While still sequencing, with notepad open the following file: C:\FileZilla\FileZilla FTP Client\docs\fzdefaults.xml.example
- Update the file so that the following code is all that remains between <FileZilla3> and </FileZilla3>
<FileZilla3> <Settings> <Setting name="Disable update check">1</Setting> </Settings> </FileZilla3>
- Save the file as fzdefaults.xml in the following location: C:\FileZilla\FileZilla FTP Client
- Check box to finish the sequencing process
Known Issues/Limitations: You can use the fzdefaults.xml file to control other settings within the application as well. In my example all that I am doing is disabling the applications ability to update. Thanks to the recipe posted by Rorymon here that got me going in the right direction.
Approximate Sequencing Time: 10 minutes
Descriptive Tags: App-V, 5.0, FileZilla, Recipe, Guidance
- Edited by CodyLambert Tuesday, January 24, 2017 6:32 PM update to include PVAD
Reply:
I have a more long form version http://rorymon.com/blog/index.php/app-v-recipe-filezilla/
Have a few up there and some over on the appv5training.com site.
PLEASE MARK ANY ANSWERS TO HELP OTHERS Blog: rorymon.com Twitter: @Rorymon
------------------------------------
Reply:
------------------------------------
Reply:
hey guys
Thanks for the recipe
I realise this version is old but just wondering if annyone had this error once before with the latest version (3.17.0.1)
I am using App V 5 and it sequences fine
I deploy it fine through SCCM, but when starting the application I get this error after the second time starting it (so first run of the application i do not get errors but after the second time i get the following error on starting the app:
------------------------------------
Reply:
------------------------------------
Reply:
I had the same problem. The package can't seem to find the "quickconnectbar.xrc" file in the resources folder even though the file exists.
If you are using App-V 5.0 you will need to sequence to PVAD.
This resolved the issue for me.
Application version 3.22.1 - Using App-V 5.0 SP3
------------------------------------
Reply:
------------------------------------
Free upgrade to Win 10 ressurected but only to businesses signed up for one of the Windows Enterprise subscription plans
Microsoft revives free Windows 10 upgrade for SMBs
excerpt:
Like the 12-month upgrade deal that ended last August, the new offer applies to personal computers running Windows 7 or Windows 8.1. But the new program is limited to a select group of customers. Only businesses that have signed up for one of the Windows Enterprise subscription plans can take advantage of the free upgrade.
"Customers subscribed to Windows 10 Enterprise E3 and E5 as well as Secure Productive Enterprise E3 and E5, can now upgrade their Windows 7 and Windows 8.1 PCs and devices to Windows 10 without the need to purchase separate upgrade licenses," said Nic Fillingham, small business product manager, in a post to a company blog Jan. 19.
My fix for "WRN1:7814 A unique match was not found."
Hi all,
Just in case anyone has same issue i thought i would share my findings on how i fixed ADMT error "WRN1:7814 A unique match was not found." during user migration.
Today when doing user migrations from a AD forest in Czech Republic to another global AD forest in USA i had problems with about 40 users out of 60. ADMT kept giving me this error:
2017-01-16 16:02:23 WRN1:7814 A unique match was not found. The source object 'CN=Aleš Popelka,OU=Tiskárna - Obchod,OU=Ostrava i Praha,OU=Ostrava,OU=MetaFrame,OU=Uživatelé,DC=Source,DC=Local' matches the following target objects 'CN=Ales Popelka,OU=Ostrava,OU=Users,OU=CZ,DC=Target,DC=Local', 'CN=Aleš Popelka,OU=Ostrava,OU=Users,OU=CZ,DC=Target,DC=Local'.
I checked in my target AD and there was only one account. so pretty sure it was not a duplicate account. Checked SIDHistory on the Target Account and there was nothing there either.
Playing around with the different merge settings during User migration proved unsuccessful so started to look at my ADMT include file which at this time was:
SourceName,TargetSam,TargetUPN
I tried to remove the TargetUPN and only have SourceName,TargetSam but still the same error.
I finally resolved the issue by changing my include file to SourceName,TargetRDN.
I am not entirely sure why this fixed it but since i did not find the answer myself on the net i thought i would share it here. in hope that someone else can use the information but also in hope that maybe someone could educate me why this was the fix.
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
WinSvr 2012 not Install in hyper-v (Some Error)
Dear Concern,
i am using windows 10 Pro and hyper-v feature install. but can't install Windows server 2012. Some error
Generation 2
Memory: 1024 MB
configuring network: not connected
Hard disk Size: 60 GB
Install an operation system later
But ISO Image conect to virtual machine and connect and then start.so having some error.
PXE Network Boot using IPv4 ( Esc to cancel)
Reply:
Can you specify the error?
does it allow to install any other OS?
Is virtualization enabled at BIOS level?
Nuno Silva
------------------------------------
Problems with Windows 10 networking
hi everyone,
I have here one laptop which I've re-installed windows 10, with a new SSD. After the installation, when we connect to the corporate vpn, we get no access. It's not kind of the limitations VPN sometimes bring. It seems to be something more "downlevel" I would say.
When I connect to the VPN, I get some minutes working normallty. After that the network status icon shows no connection(exclamation mark). I disconnect from the network, and reconnect. after reconnecting, I can ping whichever ip I want inside our LAN. I can either ping the default gateway with no problems. if I try to ping any internet ip address I get transmit failure. general failure.
At this time, I'm no longer connected with either VPN or Internet.
I've looked at the routing table, and it seems ok to me. I've cleaned up the arp table, still no luck. I've ran netsh int ip reset too, and yet it keeps bugging me.
The only way out of this is if I disable and re-enable the network card. After this step I get now internet connectivity.
So reseting the tcp ip stack is not solving. Before I consider changing the NIC(which gives me no guarantee that it will solve), do you guys have any other advise?
UPDATE - This happens with either wifi or ethernet.
Thanks
Nuno
Nuno Silva
- Edited by Nuno Pedro Silva Tuesday, January 24, 2017 2:38 PM
Ошибка удаленной установки агента Backup Exec 2010 на Win Server 2008 R2
Здравствуйте,
Не могу установить удаленно агента Backup Exec 2010 R3 на Win Server 2008 R2 для бэкапа Exchange 2010. Учетка - доменная под кот. делаются бэкапы в системе.
Ошибка следующая:
Ошибка подключения к удаленному компьютеру. Убедитесь, что компьютер доступен, WMI включен и не заблокирован брандмауэром.14
брандмауэр выключен, антивирусник отсутствет, служба WMI включена. Сетевой доступ к серверу есть. Пробовал с учеткой локального админа, дал всевозможные права, но все безуспешно. На другие сервера агент встал замечательно.
- Changed type MedicalSMicrosoft contingent staff Tuesday, May 7, 2013 2:39 AM different language
Reply:
Hi,
You could post to the following forum:
http://social.technet.microsoft.com/Forums/ru-RU/category/windowsserver
TechNet Subscriber Support in forum |If you have any feedback on our support, please contact tnmff@microsoft.com.
------------------------------------
Reply:
------------------------------------
Exchange 2010 Powershell - Export All Contacts from Selected Users Mailboxes to CSV File
I search for several days to find a script for exporting contacts from selected mailboxes using powershell. I found code snipets here and there and after much work got the export to complete sucessfully. Here is the code. I'm hoping it saves someone else the time and frustration I put in.
Thanks to all who provided snipits that are pasted together here.
$dllpath = "C:\Program Files\Microsoft\Exchange\Web Services\1.2\Microsoft.Exchange.WebServices.dll"
[void][Reflection.Assembly]::LoadFile($dllpath)
$service = New-Object Microsoft.Exchange.WebServices.Data.ExchangeService([Microsoft.Exchange.WebServices.Data.ExchangeVersion]::Exchange2010_SP1)
$windowsIdentity = [System.Security.Principal.WindowsIdentity]::GetCurrent()
$sidbind = "LDAP://<SID=" + $windowsIdentity.user.Value.ToString() + ">"
$aceuser = [ADSI]$sidbind
$service.AutodiscoverUrl($aceuser.mail.ToString())
$outputfile = "c:\ContactExport.csv"
#Header rows
'"User","First Name","Last Name","Company","Address1","City","State","Zip","Home Phone 1","Work Phone 1","Cell Phone 1","Fax/Other 1","Email 1","Home Phone 2","Work Phone 2","Email 2"' | Out-File -Encoding ASCII -FilePath $outputfile -append
#traverse mailbox and pull out All Contacts
function getcontacts ([string]$MailboxName)
{
$ContactsFolderid = new-object Microsoft.Exchange.WebServices.Data.FolderId([Microsoft.Exchange.WebServices.Data.WellKnownFolderName]::Contacts,$MailboxName)
$view = New-Object Microsoft.Exchange.WebServices.Data.ItemView(10000,0)
$findResults = $Service.FindItems($ContactsFolderid,$view)
foreach($item in $findResults)
{
"""$MailboxName"",""$($item.GivenName)"",""$($item.Surname)"",""$($item.CompanyName)"",""$($item.PhysicalAddresses[0].Street)"",""$($item.PhysicalAddresses[0].City)"",""$($item.PhysicalAddresses[0].State)"",""$($item.PhysicalAddresses[0].PostalCode)"",""$($item.PhoneNumbers[8])"",""$($item.PhoneNumbers[2])"",""$($item.PhoneNumbers[11])"",""$($item.PhoneNumbers[1])"",""$($item.EmailAddresses[0].Address)"",""$($item.PhoneNumbers[9])"",""$($item.PhoneNumbers[3])"",""$($item.EmailAddresses[1].Address)""" | Out-File -Encoding ASCII -FilePath $outputfile -Append }
}
#Pulls names from a csv file that you provide
foreach
($MailboxName in Get-Content "c:\UN.txt")
{
getcontacts -MailboxName ($MailboxName)
}
Reply:
When I run this - I get errors stating "Cannot index into a null array".
What did I miss?
------------------------------------
Reply:
There are a number of better examples for exporting contacts from a Mailbox I would suggest you check these out as the code in this post won't work where properties are null.
https://gallery.technet.microsoft.com/office/Export-Contacts-from-OWA-9f8cc0f2
http://gsexdev.blogspot.com.au/2014/02/exporting-contacts-to-csv-file-using.html
------------------------------------
"Unidentified Network" Issues - Workaround.
This thread is less a request for help, and more an offer of a workaround for this issues, since MS remains silent on it.
Issue : Network adapters remain in "Unidentified Network" mode.
Go to your Network adapter settings, and jot down your IP info if any.
Go to Device Manager and Uninstall the Problem adapter. If prompted to remove drivers, DO NOT.
Immediately after the uninstall , right click on the tree and "scan for hardware changes". You'll see the adapter
reinstall itself and begin the identification routine.
Go to the adapter settings, and re-enter your IP info. Click the "Advanced" tab and go to the DNS settings tab.
At the bottom ensure that "DNS Suffix for this connection" is set to your DN [domain.net] (do not use the FQDN here - only the domain name)
Ensure that the box for "Register connections DNS" and "Use this connections DNS" is checked.
After this you'll note that the connection properly identifies your domain / connection.
Note* The uninstalling of the adapter is required. Several threads note to make the DNS suffix changes I have listed above - but this alone does nothing in my experience - in each case only uninstalling and re-installing the adapter and re-doing the settings Worked.
I'm also betting that it's very closely related to the "Wired connections identifying as the wireless SSID" issue I've also encountered recently. (which again requires I do the same thing - uninstall and reinstall the adapters - imagine that!)
Eyes open, no fear.
Stay safe everyone.
~T
- Changed type MeipoXuMicrosoft contingent staff Tuesday, January 24, 2017 9:46 AM
Reply:
Thanks for sharing your solutions and experience. It is very beneficial. I would like to introduce it to other community members who may have similar issues.
Best regards
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
DNS Server Unresponsive
Hi Team,
Have a major issue i am facing in my working environment.
I have two public DNS servers for our customers, Windows Server 2008 R2 - Cloned from a physical (P2V) about 3 years ago.
One sitting on 1 Hyper V host, the other is on another host. All zones are replicated perfectly
The issue is; Every 3 months or so, we find that the primary DNS hangs and becomes unresponsive but the weird thing is so is the second!. Which defeats the whole purpose of having two dns servers, for one to act when the other cant.
Both gets back to normal after force reboot but i need to understand why this is happening, and why both servers can suddenly stop responding when they are on diferent host.
Please assist.
Many thanks.
Travis, A+, N+, MCTS/MCP, MCSA 2008, MCSA 2012
- Changed type Trav92 Monday, January 23, 2017 10:49 AM More ideas needed
Reply:
1. is it only DNS service not working complete VM hangs ?
2. if entire Vm hangs, is there any issue with other VMs on hyper V & any increased resource utilization issues ?
3. is there any logs before the incident ?
------------------------------------
Reply:
Hi Sumesh,
Thanks for replying,
1. The whole VM, i cannot access by remote desktop. By hyper v console i can but stuck on login page
2. Other VMs work perfectly on the two host, resources are fine. Nothing on the host log
3. The last dns log before the incident is 3.32Am on the secondary DNS {The DNS server encountered a bad packet from 121.10.242.185. Packet processing leads beyond packet length. The event data contains the DNS packet}. On the primary dns 3.59Am {The DNS server encountered an invalid domain name in a packet from 24.138.252.19. The packet will be rejected. The event data contains the DNS packet.}
The application log the last log was 12.07Am {The VSS service is shutting down due to idle timeout.}
Travis, A+, N+, MCTS/MCP, MCSA 2008, MCSA 2012
------------------------------------
Reply:
Hi Travis,
>> we find that the primary DNS hangs and becomes unresponsive but the weird thing is so is the second!.
What is the type of your DNS server?
Please try to use Debug Logging on DNS properties and check if there is any related information exist.
Have you tried to restart DNS server service when DNS server hangs? How about result?
What is the frequency of DNS hangs?
Best Regards
John
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
- Edited by John Lii Tuesday, January 24, 2017 2:37 AM
------------------------------------
No comments:
Post a Comment