SQL delete probelm
Reply:
------------------------------------
Reply:
It's not a SQL Server problem I think, probably it's more about the OS.
I've experienced this problem several times during the years, one of them was because of the key stroke to one of those "prtscn/sysrq, scrlk, pause/break" keys on the keyboard. And recently I've been experiencing this issue with a client who started using Passman Manager Pro and I RDP to the servers I manage through this app and time to time, I do not exactly know why, I experience the problem you mention. As a workaround I disconnect my RDP and reconnect and it sorts things out. Probably it's because of a key combination I use to copy and paste from the clipboard, it must have a side-effect that I haven't figured out yet.
http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy
------------------------------------
SfB Online *.onmicrosoft.com
Hey All,
Very quick one;
At present I have set up a Model Office, done all the DNS Checks, and they come back OK.
Now, one thing. When I try to connect to SfB Online, I am having to use the *.onmicrosoft.com suffix. I can nslookup the CNAME and SRV and they come back as expected. So, I downloaded the Lync Analyser Tool, and this is failing on the lyncdiscover.domain.com - now, forgive me, but if I have a CNAME for this, why is it looking for an 'A Host'?
Have I missed something out?
Thanks,
Ray :)
Reply:
It's okay, I have now resolved this.
Logged into the portal and changed the on.microsoft.com SMTP and Account to the domain.suffix - logged off and logged back in.
This will happen for all accounts created before 'all' DNS work and be carried out, and verified!
Ray :)
------------------------------------
How to resolve event ID 315 error
Hi,
Getting below error for the configuration. And made CheckChainExcludeRoot to "None" from power shell, but issue not resolved.
Thanks in advance.
An error occurred during an attempt to build the certificate chain for the claims provider trust 'XXXX' certificate identified by thumbprint 'XXXXXXX'. Possible causes are that the certificate has been revoked, the certificate chain could not be verified as specified by the claims provider trust's signing certificate revocation settings or certificate is not within its validity period. You can use Windows PowerShell commands for AD FS 2.0 to configure the revocation settings for the claims provider trust's signing certificate. Claims provider trust's signing certificate revocation settings: CheckChainExcludeRoot The following errors occurred while building the certificate chain: A certificate chain could not be built to a trusted root authority. The revocation function was unable to check revocation for the certificate. The revocation function was unable to check revocation because the revocation server was offline.
- Edited by Darshan Shivakumar Thursday, March 16, 2017 6:44 AM
office 2013 coexistence
Hello,
i have an active licence for office 2013 version home and business and an unwanted license of microsoft office professional plus 2013
http://ge.tt/6XVpzAj2
every time that i open outlock or any other office tool, a popup window appears as reminder that pro-plus lic. is expired.
all this has appened after a windows mandatory update.
i'm now looking for a way to not see this false licence anymore .
many thanks in advance
Reply:
Hi,
First recommendation is not to have 2 different versions of Office suite running on the same system. Uninstall the unwanted application and this will resolve any licensing issues.
Regards,
------------------------------------
Update KB3150513 now available via Windows Update for Windows 10 Version 1607.
https://support.microsoft.com/en-us/help/3150513/latest-compatibility-definition-update-for-windows
You can also get the download from Microsoft Update Catalog.
- Changed type david hk129 Wednesday, March 15, 2017 10:30 PM
VHD set in hyperv 2016
Hello
Please tell me on your own wording about what is VHD set in hyperv 2016. thanks
Dynamic Memory in Hyperv VM
Hello,
i have created one vm on hyper v server.
i have put memory size and dynamic memory is enable.
Startup Memory 3500 MB
Minimum Memory 512 MB
Maximum Memory 6000 MB
when i checked memory size in vm through task manager then there is mention total memory size is 3.5 GB means which i have set on startup memory. it should not be mention 6000MB which i have set on maximum size? because startup memory only use when vm will be load.
if there is 3.5 gb total size then i have mentioned on maximum size 6000MB . if VM need memory than 3.5gb then how this vm will get more memory and how it will fulfill the requirement with 6000 MB?
Please cancel
Reply:
Hi all, i was hoping someone could help me with the above question.
I've researched online about two dimensional arrays and accessing elements in an array. And how you can display an array by using a for loop. This hasn't helped.
I've found an example below online, but this is different to what i have. I'll explain below the code;
$array=@("Row1-Col1","Row1-Col2","Row1-Col3"),("Row2-Col1","Row2-Col2","Row2-Col3") for ($col=0;$col -le $array.length;$col++) { for ($row=0;$row -le $array[$col].length;$row++) { echo $array[$col][$row] } }
I have a $array1 this stores two sets of information; example get-childitem Name and Last Date Modified.
I want to access the elements in the $array1 and output this in a 2 dimensional format.
Contributors please can you add a short note how this works.
thanks in advance
If your description is correct, $array1 is actually an object.
To access the individual items, you'd use $array1[0].Name or $array1[0].LastWriteTime.
What do you mean by '2 dimensional format'?
- Edited by Mike Laughlin Thursday, September 3, 2015 7:06 PM Add quote of original post, since OP removed it.
------------------------------------
Reply:
In PowerShell we normally use objects to store related data.
Also your array is not an array;
$array=@( @("Row1-Col1","Row1-Col2","Row1-Col3"), @("Row2-Col1","Row2-Col2","Row2-Col3") ) for($c=0;$c -lt $array.length;$c++){ for ($r=0;$r -lt $array[$c].length;$r++){ $array[$c][$r] } } \_(ツ)_/
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
Ignore the example I found; but if I do get-child item it will return 10 files or another day it may return 20 files. I need to understand how to put this in a two dimensional way and to add a row for each new file. I've seen the operators ++ and += But more of what I need help with is accessing the elements in the array each time I run the script the results will be different. So the for loop will stop when it is equal to the array object count.
I would start by first learning PowerShell. Once you understand the basics you will either understand how to do this or you will be able to ask a question that makes sense.
Start here and post back when you have the basics: https://technet.microsoft.com/en-us/scriptcenter/dd793612.aspx?f=255&MSPPError=-2147217396
\_(ツ)_/
------------------------------------
Reply:
------------------------------------
Reply:
There is absolutely no need to use arrays in this situation in PowerShell. Please go study the basics of PowerShell and post back when you understand how it is intended to work.
Modern languages have not built based on arrays for more than 2 decades. We use objects. All things in PowerShell and Windows are either object or values.
\_(ツ)_/
------------------------------------
Reply:
Because it is better to use a for loop to increment each time, and a two dimensional array is like a multi dimensional array.
But you don't have an array, you have an object.
------------------------------------
Reply:
Please cancel
Okay then.
------------------------------------
Reply:
Mike - I think you were right.
\_(ツ)_/
------------------------------------
Reply:
------------------------------------
Reply:
Because it is better to use a for loop to increment each time, and a two dimensional array is like a multi dimensional array.
You cannot delete a thread. Changing the title is just very rude the way you have done it.
You can argue all you want but you still haven't understood what the discussion has been about.
\_(ツ)_/
------------------------------------
Reply:
------------------------------------
Video decoding / Youtube issues with 15055
Since I installed the latest insider preview (15055) I've issues playing YouTube video's. I tried them in both Edge and Chrome (both last versions).
It's really odd, they start pretty ok but a bit slow but if I skip forward the Chrome browser completly gets unresponsive showing a green screen for a while. If I do the same in Edge it also keeps loading. Both showing a really weird high CPU usage.
Some days ago there was also the new 378.78 nVidia driver but this behaviour started after installing the last Windows Insider Preview. I was wondering if some people had the same problem.
It could be YouTube having a bad day but try to play this link if you want... https://www.youtube.com/watch?v=iI2sgccm0LM (nice song anyway).
Reply:
------------------------------------
Reply:
Same issue here... And so close to Creators Update!
For me Facebook videos works perfect with seek and all that, but YouTube embedded videos won't seek, just like when playing them om youtube.com...
Played on youtube.com, the video may suddenly freeze during playback while embedded videos plays to the end, as long as I don't seek of course!
Then again, I've also managed to seek in a YouTube video.
May be an issue with hardware acceleration or DASH.
------------------------------------
Reply:
I had this same issue after upgrading to 15055.
Disabling HW acceleration in chorme settings solved it for me.
------------------------------------
Reply:
------------------------------------
Reply:
Same problem here. I have Nvidia 378.78 driver, GTX 1080, and installed the 15055 build straight from ISO rather than an upgrade through Windows Update. Can't seek Youtube videos without it hanging for 30 seconds and then going green. Tried Opera, Chrome, and Edge. Only solution was disabling hardware acceleration.
- Edited by Drimzi Monday, March 13, 2017 12:14 AM
------------------------------------
Reply:
------------------------------------
Reply:
Fixed in build 15058 (at least here)
------------------------------------
The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Di
- Changed type maneeshreddy Friday, March 17, 2017 11:07 AM
- Edited by maneeshreddy Friday, March 17, 2017 2:27 PM
Reply:
This can be normal. The replication agent might be applying a large transaction of the subscriber.
You might want to set querytimeout to a larger value. Also check to ensure that there is no blocking going on on the subscriber.
------------------------------------
Reply:
For merge the same rules apply. Check for blocking. Check the setting of QueryTimeOut. You can do this on your profile. Here I have created a merge replication profile called X. I have changed the setting from the default of 5 minutes to 10.
------------------------------------
VBScript sending logs
Hi, i've managed to create my script to send out log files to specific email addresses, but now i'd like it work without manually placing a date. How do i go about adding a variable for the date so that my script will send only the current days logs?
example of current script below
Set myMail=CreateObject("CDO.Message")myMail.Subject="Daily DBCheck"
myMail.From="ABC@CCC.com"
myMail.To="JJ@CCC.com"
myMail.CC="&TTT@CCC.com"
myMail.TextBody="The Daily DBCheck is attached"
myMail.AddAttachment "B:\Log\DB_CHECK_Live_20170315.log" 'NOTE: DO NOT USE AN "=" SIGN AFTER "AddAttachment"
myMail.AddAttachment "B:\Log\DB_CHECK_Stby_20170315.log" 'NOTE: DO NOT USE AN "=" SIGN AFTER "AddAttachment"
myMail.AddAttachment "B:\Log\DB_CHECK_Stby2_Wed0315.log" 'NOTE: DO NOT USE AN "=" SIGN AFTER "AddAttachment"
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing")=2
'Name or IP of remote SMTP server
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") _
="host server"
'Server port
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") _
=25
myMail.Configuration.Fields.Update
myMail.Send
set myMail=nothing
- Changed type Bill_Stewart Friday, April 28, 2017 7:47 PM
- Moved by Bill_Stewart Friday, April 28, 2017 7:48 PM Unanswerable drive-by question
Reply:
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
Also CDO will not be available in future systems and VBScript is slowly disappearing from all Microsoft sites. Its use i not recommended for security and compatibility reasons.
PowerShell can do all of that VBScript in one command.
Send-MailMessage -To <> -From <> -Subject "Todays Report $(Get-Date)" -Body <body> ...
The date in VBScript is "Now"
wscript.Echo Now
Don't waste your time learning VBScript.
\_(ツ)_/
- Edited by jrv Wednesday, March 15, 2017 1:32 PM
------------------------------------
SQL Server BI User Group Upcoming Online events
Hi
I have set up yesterday a meetup SQL Server BI User Group https://www.meetup.com/Katie-Emil-User-Group/
I wanted ask if there are any good places to share the events. Ideally I would like those where it's easy to submit an event, so I have more time to prepare for the event itself :)
I have put my events on EventBrite and I'm in process of trying to be listed on, SQLServerFAQ website and SQL Pass BI Virtual Group.
Are there any other websites related to SQL Server BI that accept user group events?
Many thanks in advance
Emil
Reply:
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from itMy TechNet Wiki Articles
MVP
- Edited by Shanky_621MVP Wednesday, March 8, 2017 6:48 AM
------------------------------------
Reply:
Hi Emil, I'd suggest the Events section on community.powerbi.com:
http://community.powerbi.com/t5/Events/ct-p/Events
Another option would be the Global Power BI User Group:
http://community.powerbi.com/t5/Global-Power-BI-User-Group/gp-p/GPBUG
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.
------------------------------------
Reply:
Hi Sam,
That looks like a great place for Power BI. I will post Power BI events there.
Do you know of any good places for T-SQL, SSIS or SSRS?
Many thanks
Emil
------------------------------------
Reply:
Hi Shashank,
I realize this is rather random place
Do you know of a better place I can ask the question?
Regards
Emil
------------------------------------
Reply:
I am sorry but you are not correct, this is not a random place but forum for users who ask questions related to MS products,SQL Server and its application. You are most welcome to ask your questions related to SQL Server here.
I realize this is rather random place
Do you know of a better place I can ask the question?
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from itMy TechNet Wiki Articles
MVP
------------------------------------
Reply:
Hi Shashank,
Just to clarify, by random I meant my question.
I was looking for a SQL Server category where community members can share or ask questions related to SQL Server events, but I couldn't find one, on the list. Is there one I should move this post to?
Regards
Emil
------------------------------------
Reply:
I think I have just find the place under one of the menus https://techcommunity.microsoft.com/ that's probably what I was looking for and couldn't find.
Many thanks for helping out
Emil
------------------------------------
Network Virtualisation: Connectivity with the outside world
Hi! We are curently testing SDN with SCVMM 2016, but I have some issues, so I wanted to discuss with someone who might know a little bit more what they are doing.
I've installed NC, deployed SLB/MUXs and gateways, but I haven't been able to communicate from my physical network to my virtual networks (vwire). I have been able to create a load balancing tool to connect to some web servers I created trough a VIP tough, but that's about it. NAT doesn't seem to work, and I'm not really sure what my network configuration should be for direct routing. I haven't tested VPN connections yet, because I lack an endpoint.
What bothers me the most is the direct routing connectivity. I think it would be the easiest way to test if the installation went smoothly, but I don't really know where my data would be coming out from. Should I plan routes in my network? Do I have to use the same subnet as the transit network?
If you know a little bit about it, please share your knowledge. Thank you!
- Edited by AlexisLessard Thursday, June 30, 2016 4:11 PM
Reply:
Hi ALexis,
I would recommend you use our Layer-3 Forwarding Gateways to connect physical networks with virtual networks. The forwarding gateway will allow you to route between physical and virtual subnets. You can specify either static or dynamic routes (BGP). Read here for more info: https://technet.microsoft.com/system-center-docs/vmm/Manage/deploy-a-ras-gateway-using-vmm
Also, I'd be interested in understanding your network topology a bit more to know how you're physical and virtual subnets are configured, what IP prefixes / masks you are using, next-hops, etc.
Thanks,
Jason
------------------------------------
Reply:
Hello Jason,
Thanks for the answer. I've been talking to Subba Raju and Uma Mahesh about this issue and about the script in the link you provided me. The plan of my lab is shown below. I can email it to you if you want.
I have two hyper-V hosts. The VMM server is not in the lab, but it is routable to all the networks depicted. Gateways have been deployed using the EdgeServiceTemplate available on github. the gateways json have some errors on it, notably:
"configurationState": { "status": "Failure", "detailedInfo": [ { "source": "ResourceGlobal", "message": "Unable to configure SLB rules", "code": "HostUnreachable" }, { "source": "ResourceGlobal", "message": "Unable to push configuration to Gateway", "code": "HostUnreachable" } ], "lastUpdatedTime": "2016-07-28T00:03:24.1551787-04:00" }, My networks are as such:
- Management: 10.12.104.0/24 vlan 104
- HNVPA: 10.12.105.0/24 vlan 105
- Transit: 10.12.106.0/24 vlan 106
- 10.12.99.0/24 is the management network we use for the switchs and other tests in the lab.
My bgp peer I've been using for my tests (notably with SLB, wich worked pretty good, btw) is my tor switch, using the loopback address 1.1.1.1. Since the tor switch is also the default gateway for all of my networks, I can ping this adress from all of my vm's connected to any physical network in this topology. It is of course not routable from the outside of the network.
Subba Raju and Uma Mahesh were telling me that layer 3 forwarding works by vlan separation, wich means that I need to create a new vlan and a logical network connected to this vlan (and direct access vmnetwork connected to it) to use as my next hop. The LocalIpAddress and peerIpaddress should both be on that network. The gateway subnet isn't connected to the outside world, as it's the CA space of the VMGateway. I'm still not sure I fully understand how I should use this.
I think what I don't understand is how my routing infrastucture should be configured, and how I could integrate bgp into the script. I know I can use -EnableBGP $true parameter and -AutonomousSystemNumber in the Add-SCVMNetworkGateway cmdlet, as well as the Add-SCBGPpeer cmdlet. What I'm not sure is what those settings are suppose to advertise to my bgp peer, and how I should peer my tor switch to my VMnetworkGateway.
I'm available to talk about the problem and how we could integrate layer 3 forwarding in this lab. I can create any vlan required. They probably won't be routable to the outside of the lab but I think the test woulb be successfull if I could ping the isolated VM's from the tor switch. Feel free to ask more questions.
- Edited by AlexisLessard Friday, August 5, 2016 3:34 PM
------------------------------------
Reply:
Hi AlexisLessard,
Did you get this resolved? I face the same/similar issue. I have gotten inbound nat working but outbound nat is not working for me.
------------------------------------
Enregistrement d'un diaporama Powerpoint 2016
Enregistrement d'un diaporama Powerpoint 2016
Quand je veux enregistrer mon diaporama, je vais sur enregistrer sous, mais la phrase suivante s'affiche : impossible car en lecture seule ?
Quelle procédure dois-je effectuer ? Si je change le nom du diaporama ou l'emplacement comme il me demande du faire, çà ne fonctionne pas.
Je n'avais pas ce problème avec l'ancienne version de Powerpoint.
Cordialement
- Edited by Minique 007 Tuesday, March 14, 2017 12:56 AM
- Changed type Ethan HuaMicrosoft contingent staff Wednesday, March 15, 2017 7:58 AM non-english post
- Moved by Ethan HuaMicrosoft contingent staff Wednesday, March 15, 2017 7:59 AM non-English post
Reply:
Hi,
Thank you for visiting our forum.
The forum that you posted is the English only forum for Microsoft Office. To avoid any misunderstanding that may be caused by the translation tool and better help you, please describe your issue in English. Alternatively, you could post this issue in other forums with the right language.
You can also contact the local support from the link below:
http://support.microsoft.com/select/default.aspx?target=assistance&c1=505&
Thanks for your cooperation and your understanding is greatly appreciated.
Note: You can choose the right language by clicking the Change button from the left bottom of the page, and select the right product.
Regards,
Ethan Hua
Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
Creating a tabbed announcements page using OOTB functionalities
I'm trying to create the following Announcements Page:
The page will consist of the following sections:
- Links / Tabs section - contains tabs or links which when clicked, will filter the Announcements displayed by that category.
- Content section - contains various views such as Pinned announcements, Recent announcements, etc. Additionally, displayed announcements will depend on the selected category from the Links / Tabs section.
I am only attempting to create the Page using mostly OOTB functionalities as much as possible. So far, here is my current approach:
Multiple pages and lists approach
- Create an "Announcements" List for each Category. (3 Lists in total)
- Create a separate Page for each Category. The links from the Links / Tabs section will then link to the appropriate Category Announcements Page (3 Pages in total)
- Configure Content Query Web Parts with custom item-style on each of the Category Announcements Page. I tried different item-styles and no OOTB fits what is needed to display something similar to above, not sure if I just missed it. The Discussion Board view seems to be the closest but still needs to be re-arranged.
However, I'm thinking if there is a way to only use a single list and page to achieve the same purpose. I will outline what I think below but I have problems thinking up of OOTB ways mainly for the "Tabs" and "Filtering by category" functionalities.
Single page and list approach
- Create an Announcements List. Configure the list to have a custom column "Category".
- Create a page and configure Content Query Web Parts with custom item-style. These will represent the "Pinned", "Recent", etc. sections for displaying relevant announcements.
- PROBLEM: For filtering category, one approach would be to create "tabs" instead of links. However, these need custom development via jQuery and Web Part Zones so I am trying to avoid this (I believe tabbed web part zones from 2007 has been decommissioned). Another approach I am thinking is configuring the links as "filter" web parts which will change / configure the filter being done by the CQWP based on the selected category. However, this will also require custom development as filter web part cannot be connected to CQWP
A last approach I thought about is something like a hybrid, creating only a single Announcements List but creating multiple pages and configuring different CQWP queries.
Hybrid Approach
- Create a single Announcements List with "Category" column.
- Create multiple pages for each category. Configure CQWP to query only items relevant to the specific category.
What would be the best way to achieve the Announcements Page using OOTB functionalities? Custom styling is ok, but any script / code is to be avoided.
- Edited by OCS.New Monday, March 13, 2017 10:48 AM
Reply:
cameron rautmann
------------------------------------
Reply:
There is no OOTB tabbing solution in SharePoint 2013, but it's easy to implement via JS, or you can use a free solution that I have used successfully in the past: Easy Tabs.
------------------------------------
Reply:
Hi OCS- if I understand all this correctly, you're overthinking it. Why not just have one list with categories and set up views for each category. Select each view in the list, then copy the URL of the filtered page, add a button and insert that link. Let me know if I'm missing something or if you need more details.
cameron rautmann
Hello!
Initially that is my approach but didn't go with it because of the following reasons:
- Needed to display the 'previews' for the content based on the style above (and not a typical list view)
- Need to have more than 1 section view aside from "Pinned", so something like "Recent", "Expired", etc. Then if I have 5 section views and 5 categories, I will have 25 Views to create for my list.
------------------------------------
Reply:
Thanks for sharing that solution but it's not really that it's difficult, its more of a policy to not use any custom code in the solution. But I will keep that in mind for future projects!There is no OOTB tabbing solution in SharePoint 2013, but it's easy to implement via JS, or you can use a free solution that I have used successfully in the past: Easy Tabs.
------------------------------------
Reply:
Just an update, I solved my problem. Turns out there's a thing called "PageQueryString" filter where you can use the URL to add a filter query parameter for the CQWP. So I just added a "Category" column to the List, then configured the CQWP to have a [PageQueryString:Category] filter. So when I type or link the URLs I just need something like "../AnnouncementsPage.aspx?Category=Category1".
So now, I just have 1 List and 1 Page without any customizations.
------------------------------------
New insider preview build...... 15058 now available.
Announcing Windows 10 Insider Preview Build 15058 for PC
Please read Known Issues for PC section.
No problem downloading with a disabled UUP system.
Install.esd can be found in Sources folder, if you want it before clicking Restart Now.
So much easier to create an iso file this way.
No watermark.
No expiry date.
- Edited by david hk129 Wednesday, March 15, 2017 3:07 AM
- Changed type Carey FrischMVP Wednesday, March 15, 2017 5:07 AM Comment
SC Service Manager runbook questions
Hello All,
I'm trying to create a runbook that whenever an incident whith source "Portal" is updated sends me an email.
and
But it is not working, what am I doing wrong?
Can anybody help me?
Regards,
Reply:
Hi,
Get Incidents will get the incidents that are fullfilling the filter, so all incidents in SCSM that have a source equals to Portal, that includes closed incidents too. A "Get" activity will run once, when you run the runbook. If you want it to run for example every 5 minutes you need to put a Scheduling activity in front of it, to trigger the runbook. But if you instead replace the Get Incident to a Monitor Object activity it will monitor Service Manager for a change that fullfill the filter and then trigger the rest of the runbook. So replace the Get Incident activity with a monitor object activity. Configure the Monitor Object activity to work with the Incident class and the filter you have in the image.
Anders Bengtsson | Microsoft PFE | blog at http://www.contoso.se
------------------------------------
Reply:
Hello Anders,
My activitiy "Get Incidents" is an Monitor Object activity, but doesn't work.
When I sincronize my orchestrator connector in Service Manager I don't see this runbook, is this is expected?
Regards
------------------------------------
Reply:
Andreas Baumgarten | H&D International Group
------------------------------------
Reply:
Couple of comments that may help.
The way you have the initial activity configured, it is only going to respond to existing incidents that are updated. It will not fire on new incidents. Not sure if that's the behavior you're going for or not.
We need some more information to determine where this isn't working. The question is if the runbook never fires at all, or if it is running but isn't sending the mail as you are expecting. Have a look at the Log and Log History for the runbook. If there is no entry, then the runbook isn't firing at all. If there is, then you should be able to get some information as to what might be going wrong. You can view the logs from the bottom pane of the Runbook Designer when the runbook is selected.
This posting is provided "AS IS" with no warranties, and confers no rights. Use of attachments are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
------------------------------------
Reply:
Hello Brian
Thanks for the response, tyes his is the behavior I'm waiting.
The runbook never fires at all, in log History has noinformation:(
I have another runbook associated with a service request and is working well.
Thanks for the response
------------------------------------
Reply:
Hi,
there are two different interfaces for Service Manger and Orchestrator (of course you can combine them).
1. In Service Manager in Administration you can define a Connector for Orchestrator. Which will connected to the Orchestrator Webservice (http://<OrchestratorWebServer>:81/Orchestrator2012/Orchestrator.svc/). In this connector you specify a sync folder (or all Runbooks), where Service Manager can trigger Runbooks with a "Runbook Automation Activity".
2. You use the Integration Pack for Service Manager here (regarding to you first post in this thread). With this IP Orchestrator triggers Service Manager. So, this Runbook looks with the "Monitor Object" Activity for updated Incidents from Source Portal if its started.
- The Runbook starting with the "Monitor Object" Activity must be started to recognize updates to the Incidents from source Portal. Is this Runbook Started? Do you see a Running Instance in the Log if the Runbook is selected?
- Can you start a Runbook with the "Get Object" Activity (Class: Incident, Filter: Source = Portal") and check if you have such Incidents. If the "Monitor Object" Activity is started and you update such an Incident. This Monitor doesn't trigger? Any Errors in Tab Events at this time?
Regards,
Stefan
German Orchestrator Portal , My blog in English
- Edited by Stefan HorzMVP, Editor Tuesday, October 2, 2012 8:10 AM
------------------------------------
Reply:
Hello,
Thanks for your help, I achived create and run my runbook.
Thanks for all the support.
------------------------------------
Reply:
Hi,
We are trying to create a Monitor Object in Orchestrator runbook. However, the synced from Orchestrator to SCSM is not working. You indicated that you have achieved such task. Could you share with us?
Thank you!
------------------------------------
Reply:
Andreas Baumgarten | H&D International Group
- Edited by Andreas BaumgartenMVP Monday, March 13, 2017 3:27 PM
------------------------------------
Reply:
Andreas,
If we use the runbooks to check for new incident with affected Service printing then populate the support group with Hardware Support Team. How do you do it in runbook? Do you have any documentation that you can share for accomplish such task?
Thank you
------------------------------------
Reply:
You have three options to start a runbook:
With a Schedule activity -> The Schedule activity will start a runbook based on the configured time values -> Runbooks with a Scheduler activity will not be synced in SCSM -> SCSM can't start/trigger these Runbooks anyway.
With a Monitor activity -> Orchestrator will take care for this and will start the Runbook based on the criteria of the monitor activity -> Runbooks with a Monitor activity will not be synced in SCS -> SCSM can't start/trigger these Runbooks.
With a Initilze Data activity -> These Runbooks will be synced in SCSM. In SCSM you have to create a "Runbook Activity Template". In this template you can configure the property/properties SCSM will send to the Runbook in Orchestrator and the Runbook will be executed.
Maybe this TechNet article is helpful:
Using Runbooks in System Center 2012 - Service Manager
Andreas Baumgarten | H&D International Group
------------------------------------
Reply:
We created a Monitor object that is to monitor the incident class. The Monitor object has no filters and the New and update options were checked.
1. Checked in the Runbook, then click on Run in the SCO Runbook Designer.
2. Created a new incident, the runbook monitor object is suppose to fire up, but it got hang up in the Monitor object. Can you help?
Thank you!
------------------------------------
March 2017 Security Patches
Hi all,
Today is the second Tuesday of the month and again (like February 2017) I have not seen any security patches for March 2017 and Microsoft have not announced anything thus far.
Anyone aware what on earth is going on?
Regards,
Ruman Muhith
- Edited by Ruman Muhith Tuesday, March 14, 2017 2:16 PM
Reply:
Hi Ruman Muhith.
The roll out has started, the updates are available.
Bye.
Luigi Bruno
MCP, MCTS, MOS, MTA
- Edited by Luigi BrunoMVP Tuesday, March 14, 2017 9:13 PM
------------------------------------
USB Copy to Network Drive (Independent of Drive Letters)
I can quite easily produce a script using the copy-item cmdlet however this is dependent on the USB stick having the same drive letter each time the script needs to be run, again I know I can use a user defined variable however this needs to have little to none user input - this is utility aimed at being used for perhaps less inept users.
So the script needs to be able to autodetect what drive letter the USB storage is using on any machine and be available to use with any external device regardless of make etc...
Third party software unfortunately isn't an option so this will have to be either PowerShell / Batch.
Any ideas?
Thanks much appreciated,
Ayden
- Changed type Bill_Stewart Friday, April 28, 2017 8:36 PM
- Moved by Bill_Stewart Friday, April 28, 2017 8:36 PM This is not "scripts on demand"
Reply:
Start by reading this post first. It's right at the top of this forum:
This forum is for scripting questions rather than script requests
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
\_(ツ)_/
------------------------------------
Flat file source CSV not importing to SQL table using SSIS
I know there have been a lot of post about the title above and I had the same problem but my solution was different from the other post . I just want to share it in case it could be helpful to others.
I imported multiple files and some of them where successful and some them did not import using SSIS package. I viewed the files in Notepad and the files that were not successful had no line break. In the connection manager, I was using {CR} {LF} in the Header row delimeter and column row delimeter. Changing to {LF} fixed my problem.
Reply:
The above issue is causing due to bad files/data corruption inside the files.Thanks for sharing.
Please Mark this reply as answer if it is helpful. Or please click on up-arrow above the "Vote"
------------------------------------
Reply:
The above issue is causing due to bad files/data corruption inside the files.Thanks for sharing.
Please Mark this reply as answer if it is helpful. Or please click on up-arrow above the "Vote"
??
Or they are Unix-formatted?
------------------------------------
No comments:
Post a Comment