Chat / IM

2K

Solutions

9

Articles & Videos

4K

Contributors

Instant messaging (IM) is a type of online chat that offers real-time text transmission over the Internet. A LAN messenger operates in a similar way over a local area network. More advanced instant messaging can add file transfer, clickable hyperlinks, Voice over IP, or video chat. Non-IM types of chat include multicast transmission, usually referred to as "chat rooms". Depending on the IM protocol, the technical architecture can be peer-to-peer (direct point-to-point transmission) or client-server (a central server retransmits messages from the sender to the communication device).

Share tech news, updates, or what's on your mind.

Sign up to Post

I need to get the count of error messages from a SQL database table over the past 24 hours.

Example:

Time:              Count:
1:00 AM         5 errors
2:00 AM         1 error
3:00 AM         10 errors
4:00 AM         5 errors
.......

12:00 PM       0 errors
.........

10:00 PM       6 errors

and so on. Below is my attempt but it is not correct.
select COUNT (messageType) as [Count], Datestamp
from Table1
where Datestamp between dateadd(hour, -24, CURRENT_TIMESTAMP)
AND CURRENT_TIMESTAMP
GROUP BY CAST(Datestamp as DATE) ,CASE
      WHEN DATEPART(HOUR, Datestamp) > 12 THEN DATEPART(hour, Datestamp) - 12
      ELSE DATEPART(Hour, Datestamp)
END , dateadd(hour, datediff(hour, 0, Datestamp), 0), Datestamp
ORDER BY dateadd(hour, datediff(hour, 0, Datestamp), 0) ASC;
0
[Webinar] Learn How Hackers Steal Your Credentials
LVL 8
[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Popular third-party chat platforms like Slack, Discord, and Telegram are just a few of the many new productivity applications that are being hijacked by cybercriminals to create command-and-control (C&C) communications infrastructures for their malware campaigns.
0
I have recently seen an increase in my users wanting to use third party messaging apps, specifically WhatsApp, to transfer company information between them and other employees. I am curious as to the community's thoughts on this, and if you allow it, how do you manage it without it getting out of control or presenting security concerns?
1
I'm looking for ways to tell our users if the server will be going down or for emergencies. E-mail is to slow because most people do not check their email for hours at a time. First would it be safe to open up an inbound port for 445, only allowing IT department IP addresses (possible spoofing issues)? What are the other options that you have used to tell your co-workers when a server is going down besides e-mail?
Thanks
0
I am facing the issue when loading .dat file to sql table and the .dat file format is like
"V","02E300058PU00E","","GEARBOX "," ","N","Y"," ",01500.00,01500.00,01500.00," "," "," ","","N","001"
"B","02E300058PU00P","","GEARBOX "," ","N","Y"," ",00750.00,00750.00,00750.00," "," "," ","","N","001"
"B","02E300058PX00E","02E300058PX00P","GEARBOX "," ","AKL","Y"," ",03150.00,04199.99,04199.99," "," "," ","02E300058PU00E","N","001"

i an using the only few selected column fields column 1,2,4,9,10,11 but getting error

[Data Conversion [39]] Error: Data conversion failed while converting column "Copy of Column11" (110) to column "Copy of Column11" (63).  The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

[Data Conversion [39]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "Data Conversion.Outputs[Data Conversion Output].Columns[Copy of Column11]" failed because error code 0xC020907F occurred, and the error row disposition on "Data Conversion.Outputs[Data Conversion Output].Columns[Copy of Column11]" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
I tried from flat file source and using data conversion but after that unable to load data in stagging table.
0
Is it possible to establish Skype for business account for helpdesk staff  (Tech 1, 2, 3, etc.) that separate than their user account without establishing domain accounts for those and logging in as those users?  Thanks
0
I need to set PHP to write to a file.
When I run this code -

    <?php
error_reporting(E_ALL);ini_set('display_errors', 1);
$myfile = fopen("newfile.txt", "w") ordie("Unable to open file!");
$txt = "John Doe\n";
$txt = "Jane Doe\n";
echo "PHP worked ?";
fclose($myfile);
?>

there are no error messages in FireFox, just a blank screen.
there is a 500 server error in Internet Explorer.

Is there something wrong or the placement of the error_reporting code?
PHP is running properly through the server other than I'm sure there are errors trying to write to the file.

Thanks,

Michael
0
I've deployed skype for business and all feature is working when both clients are in corporate network. But, Desktop/Application sharing and Audio/Video call is not working from external to internal and Vice versa.

My edge server configuration is
 The server is located on perimeter network.
 Two NIC interfaces connected to the edge
Three public ip address is natted to three Ip address  using same port 443
Each three Public Ip adress is reserved for Access, Audio/Video and Web conferencing
Every required ports are opened on the fire wall.

Please assist!!
Appreciate your answer.
0
Hi

I am updating an XML file and using XML::LibXML

My attribute value that I am replacing is

DESCRIPTION="== Conversion Messages Start ==&#xA;&#xA;Message ID : INF11004 (31284-19308)&#xA;Description : An empty RBC is added..&#xA;&#xA;== Conversion Messages End ==&#xA;FTP to FTP"

When i try to substitute using the following code the data is not changed.
just trying to move the last line to the beginning line.

$AA =~ s/(.*)== Conversion Messages End ==(.*)/$2 $1== Conversion Messages End ==/;

Output is

== Conversion Messages Start ==

Message ID : INF11004 (31284-19308)
Description : An empty RBC is added..

 == Conversion Messages End ==
FTP to FTP


where it should be

FTP to FTP
== Conversion Messages Start ==

Message ID : INF11004 (31284-19308)
Description : An empty RBC is added..

 == Conversion Messages End ==


I believe its due to the line endings which is causing it to not get the first (.*)


not sure how to get the correct output.

Thanks for the help

Mike
0
users at this small business are not receiving new email messages.  Outgoing messages seem to flow. The POP3 Connector is in use and email is being fetched properly by the POP3 connector but then not getting routed into the exchange mailboxes.

The application windows logs shows Exchange Transport errors: Event ID 5015, Microsoft Exchange cannot find a route to the source transport server or home MTA Server.

Also Event ID 5016, The Active Directory topology service could not discover any route to the connector
0
On Demand Webinar: Networking for the Cloud Era
LVL 8
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Have the following messages showing up in Exchange EV:

(PID 4612, Thread 154) Task Get-HealthReport throwing unhandled exception: System.ArgumentException: sessionState
   at Microsoft.Exchange.Configuration.Tasks.ExchangePropertyContainer.GetProvisioningBroker(ISessionState sessionState)
   at Microsoft.Exchange.Provisioning.ProvisioningLayer.GetProvisioningHandlersImpl(Task task)
   at Microsoft.Exchange.Provisioning.ProvisioningLayer.GetProvisioningHandlers(Task task)
   at Microsoft.Exchange.Configuration.Tasks.Task.<BeginProcessing>b__4()
   at Microsoft.Exchange.Configuration.Tasks.Task.InvokeNonRetryableFunc(Action func, Boolean terminatePipelineIfFailed).

Ran this Get-HealthReport in PS:  Get-HealthReport -Identity exchange-svr | where-object {$_.AlertValue -eq "Unhealthy"}

State               HealthSet           AlertValue          LastTransitionTime  MonitorCount
-----               ---------           ----------          ------------------  ------------
NotApplicable       Compliance          Unhealthy           6/8/2017 4:05:49 AM 29
NotApplicable       ActiveSync.Protocol Unhealthy           6/7/2017 9:29:43 PM 7
NotApplicable       Autodiscover.Pro... Unhealthy           5/29/2017 11:04:... 8
NotApplicable       EWS.Protocol        Unhealthy           5/29/2017 11:12:... 8
Online              HubTransport        Unhealthy           5/30/2017 1:28:3... 97
NotApplicable       OWA                 Unhealthy           5/29/2017 10:50:... 18
0
Keep getting messages saying my free one drive is nearly full. I know it isn't as I have removed lots of files. Scam to try to get me to upgrade??
0
I was having twitter forward tweets to my cell phone as SMS messages. I signed up for loads of news sites and got a message about 200 messages / day limit...

Then I got the twitter app for IOS and was getting the messages on my lock screen from both twitter and messages. I turned off forward messages to phone.

Then in last couple days, I stopped getting any tweets.

was there an update in ios twitter account?    I went into the twitter app and see a bell with check icon.  (was it there before) checked that and a window labeled account notificiations was set to none. I changed that to all tweets now I get the tweets twice.

how do I only get tweets from only the ios app and showing up on the lock screen on the iphone?
0
We have a Coexistence environment with Exchange 2010 and 2016.  I migrated two mailboxes to the Exchange 2016 Server and those two mailboxes cannot Send mail (internally or externally)
Those messages get stuck in the Outbox.
Any suggestions?
0
Our company's current Transport Limits in Exchange Server 2010 are set to 20,000kb  for "Maximum Receive Size" as well as "Maximum Send Size".  I would like to increase it to 30,000KB.  For reasons other than storage space on our server (which we have plenty of), is there any other reason I should not be increasing those parameters?

Also, if a sender was sending one of our users an email containing attachments exceeding the current 20,000KB and our settings remained at 20,000 KB, would the sender receive any messages indicating that the email was not delivered to us if they do not request a delivery receipt? (i.e. would they receive notification that the attachments were too large for out limits and advise the sender that the email was not successfully sent?).
0
I have a client using outlook 2013 to send mail to a client list that is generated by Access 2013. About 35 percent get the attachment as a winmail.dat instead of PDF.

I have followed the advice on the internet:
1. Open up your Outlook email client.
2. Click on File located in the upper toolbar.
3. Select the Options setting.
4. From here, select the Mail category.
5. Now, under Compose messages, you want to ensure the HTML or Plain Text option is selected for the Compose messages in this format.  style="clear:both;">
6. Next, underMessage format, set When sending messages in Rich text format to Internet recipients to Convert to HTML format or Plain Text format
7. Click OK to finish.

I Tried both HTML and Plain Text format, still having issues..

We are using outlook client, no exchange and we are using a gmail account for the smtp.

Any suggestions....
0
When sending a mail in outlook 2010,the mails are stuck in the outbox and its not leaving the outbox unless the outlook is closed and open.
0
Anyone know a way of doing the above?  I cannot see google drive as an option in the iphone whatsapp chat backup settings?
0
Hi guys,

See diagram.

In this example, the DR is elected at SVI 200 (right distro), but the transit link between the core and distro, the core will be elected as the DR for multicast.  

Is it correct to say that multicast traffic will not pass, because we are unable to send the initial join messages upwards toward the RP because the DR is incorrectly configured?
DR-Multicast.png
0
[Webinar] How Hackers Steal Your Credentials
LVL 8
[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Regarding "recent stickers" used by me on my mobile.

They can disappear from my mobile? Even though I don't used them again?

Thanks so much
0
i have two oledb destinations after this im loading error data to text file and iam using union all for combining data im getting below error
[SSIS.Pipeline] Error: SSIS Error Code

DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on

component "Union All" (990) failed with error code

0x80004005 while processing input "Union All Input 3"

(1198). The identified component returned an error from the

ProcessInput method. The error is specific to the component,

but the error is fatal and will cause the Data Flow task to

stop running.  There may be error messages posted before

this with more information about the failure.
0
I recall a few years ago that I used a program similar to Skype which allowed me to have private conversations via this tool.

There was some sort of key that I generated on my PC and emailed to the other person, which that person added to this tool. We then have "private" conversations.

Does this sound familiar to anyone? That does tool, or another, offer this today?

Thanks.
0
how to export archive email messages from Barracuda Message Archiver?
0
I have setup a Windows 2016 SMTP server to use for mail relay. When I send a test messages using the new SMTP server, the message is delivered. When I look at the logs, it shows me connecting from my workstation, then somehow it is sending the SMTP traffic over to my Exchange server. I don't want this to go through my Exchange server. I want the new SMTP server to do the sending.

Any ideas on how/why it is going to my Exchange server?
0
Hello

I learning up about Skype Enterprise Voice and it's potential for mobile.

Right now, we use Skype for Skype-to-skype calls. I'm wondering if this can be integrated with the telephone line in the office.  And then, if we can deploy a Skype mobile client to user's personal devices that has their office number....this way, we can :

1. A user never has to give out their personal mobile number, only their office number which will now ring on their personal phone

2. A user can make voice calls, either internally or externally, using this Skype client and reduce cost to them since it presumably uses the corporate network where possible, e.g. for international calls.

Some questions.

1. Is Enterprise Voice the term for the integration of Skype with the phone network

2. When we refer to the Phone Network, do we mean PSTN?

3. Is there a way for an enterprise Skype mobile client to have an external dialler feature so the user can phone anyone, either internal or external?

4. Are there potential cost benefits of this Skype client connecting to the corporate network

5. Is it possible for Skype mobile to have the user's office desk number so that it provides the fixed mobile convergence i talked about? Or does it need a separate number?
0

Chat / IM

2K

Solutions

9

Articles & Videos

4K

Contributors

Instant messaging (IM) is a type of online chat that offers real-time text transmission over the Internet. A LAN messenger operates in a similar way over a local area network. More advanced instant messaging can add file transfer, clickable hyperlinks, Voice over IP, or video chat. Non-IM types of chat include multicast transmission, usually referred to as "chat rooms". Depending on the IM protocol, the technical architecture can be peer-to-peer (direct point-to-point transmission) or client-server (a central server retransmits messages from the sender to the communication device).